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

rating

linking a distinct list to a detail page

Thread began 4/03/2019 9:18 am by john70964 | Last modified 4/08/2019 11:13 am by Ray Borduin | 56 views | 9 replies |

john70964

linking a distinct list to a detail page

Hello Ray
I am trying to link a distinct recordset list to a detail page.
I tried to do this via the data assist pages but could not see that this was possible.
I created a distinct list but cannot seem to connect this to the detail page.
am I on the right track?

I have attached the two files

Many thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

You are doing a form post and your select name is "ManSearch"... then on your details page you are filtering the recordset with:

$_GET['RecNo']

You should filter it with:

$_POST['ManSearch']

To match the post and form element name from your search page.

The other option would be to change your form method to "get" and change the select name to RecNo to match the details page.

Sign in to reply to this post

john70964

Thanks Ray,
I realize now that I am a step missing
I have my distinct list which has a number of manufacturers and each manufacturer has a selection of models. I think therefore after the list I need a results page and then a details page.
As this largely is already built in WebAssist > Database .> DataAssist Pages can the Search created be changed to a recordset to give a distinct list.
The search page is created with a Form Get: can this be changed into a recordset easily!?

Thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

You can have the second page recordset filter and show another list and then have it filter to show the final result. It could be done easily. Give it a try and ask a specific question if you get stuck. Go one step at a time.

Sign in to reply to this post

john70964

Thanks Ray
I created a page with a select list with the idea that on a select being made this would open a results page then a details page.

But when a manufacturer selection from the list is made, the results page does not open.

I am attaching the files.

TIA
John

Sign in to reply to this post

Ray BorduinWebAssist

If you want a select list to automatically submit a form when you change the selection you can add an onchange event to the <select> tag like:

onchange="this.form.submit()"

Sign in to reply to this post

john70964

Thanks very much Ray,
I amended this line and it works 100% as needed.

<select name="search-distinct" size="1" id="search-distinct" onchange="this.form.submit()">

Cheers
John

Sign in to reply to this post

john70964

Hello Ray
From the distinct list above I am trying to open a results page.

I cannot get the results page to pull in the selection from the search page.
Can you see what is wrong please?
Thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

You should have the filter on the results page set to filter based on: $_GET["search-distinct"] but you are filtering based on: $WADAboats->getColumnVal("Manufacturer") (which makes no sense... you can't filter a recordset by itself). Change that on line 6 of your results page and it should start working properly.

Sign in to reply to this post

john70964

Thanks again Ray for the wonderful support.

You are spot on and that sequence of pages is working fine.

Thinking back, first I created the select list working with your advice. Then I used Data Assist Pages to create the Results and Details but I could not get the Results page to open with any records.

I think that's when I changed $_GET["search-distinct"] to $WADAboats->getColumnVal("Manufacturer")

Now I have a working model I will create another similar test sequence to ensure I can!

Sign in to reply to this post
loading

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...