close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Colname not working

Thread began 12/28/2018 6:51 am by john70964 | Last modified 1/04/2019 5:25 pm by john70964 | 180 views | 8 replies

john70964

Hello Ray
In the past i have created many links but at the moment I do not seem able.
This seems to have occoured after updating to DB 234, I must now be making some basic mistakes.
Is ther a tutorial anywhere for this. I found one of JB's but it was many yearsold now and out of date.

To try to understand where I am going wrong I copied my steps.


I create a link on the list.php named Details
Link box shows details.php
On the right hand side Of the link box there is a folder.
I select the folder and use the Data Sources tab to select RecNo
This produces code on the list.php page of
<a href="<?php echo($rsCanalBoatList->getColumnVal("RecNo")); ?>">Details</a>
It appears the target of page Details.php is missing.

When I hover over the link I see http://localhost/boatsforsalenow_mysqli/categories/119898
I can correct this by inserting detail.php
reating <a href="details.php<?php echo($rsCanalBoatList->getColumnVal("RecNo")); ?>">Details</a>
which arrives at the correct page.

On the details.php page I deleted the recordset to insert a new one.
I selected Query builder (which seems very slow) and dragged the boats table
I select the few column names required.
After this I selected Advanced Builder
I selected Where RecNo comparison value is set to URL Parameter and I entered RecNo in the box and OK.

On the page this brought up a syntax error on line 4

I deleted the recordset and reset the page
I created a new recordset rsDetails in Simple format
with RecNo Url Parameter and RecNo
I then selected Advanced
I selected Edit in the Variables Column whci showed
Colname Interger -1 $_GET['RecNo'] I selected OK and OK again
==================================================================
When I ran the pages
The url shows on the List page appears to be correct and when I press the link
the url shows as http://localhost/boatsforsalenow_mysqli/categories/details.php11898
which is also correct
But I get the error
Object not found!
========================
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated.
Please inform the author of that page about the error.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.29 (Win32) OpenSSL/1.0.2l PHP/5.6.32
============================
I have placed the files at

http://net100test.co.uk/WA_DB234/BFSN_full/categories/list.php
ftp detail
Ftp Detail
Server: home415519235.1and1-data.host
Port: 22
Protocol: SFTP
User name u68925687-Mysqli_tes
Password P0lyg0n&20*&

I think when I get clear on the system of getting the links to work
I will publish the method on the forum to help me if ever I get into a pckle again.
(If that is Ok)

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...