close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dynamic Dropdown menu

Thread began 10/20/2015 4:15 am by Daniel | Last modified 10/27/2015 1:27 pm by Ray Borduin | 898 views | 8 replies |

Daniel

Dynamic Dropdown menu

Hi.
Hope you are doing well?
I’m busy building a website for an estate agency. I have attached 2 pictures so that you can have a look at what I am planning to do and have done so far.
You will see that in the ‘FinnishedPage.jpg’ picture is the search functionality of what I’m planning to do. It has 5 options:
1. Province – Dropdown with 9 provinces – Provinces stored in Database(dropdown comes from database – did it with ‘select list’).
2. City – Dropdown with Main City of each province except 1 Province that has 2 cities – Cities stored in database.
3. Area of City/Suburb – Only one of the cities has ‘Area of City/Suburb’ which is also stored in the database.
4. Price – Stored in database.
5. Property Type – Stored in database.
How the above is supposed to work is: When the visitor chooses a province from the ‘province’ dropdown menu – that province’s main city is supposed to appear in the ‘City’ dropdown menu. So there is one city called Pretoria – if that city is chosen certain ‘Area of City/Suburb’ of that one city is supposed to appear in the ‘Area of City/Suburb’ menu.
Because what is is that I want to do is once they have chosen on the search menu it must search the database for the Property that the client has put in.
I went through one of the Dynamic dropdown tutorials – So what I saw was that the Dynamic dropdown only has the Parent Child option. Is there another way for me that will be applicable to what I want to use?
Thank you for your assistance.
Daniel.

Sign in to reply to this post

Ray BorduinWebAssist

You would just have to apply Dynamic Dropdowns more than once to cascade the parent-child relationship across to the third or more dropdown.

Sign in to reply to this post

Daniel

Okay thank you. I will try and then let you know

Sign in to reply to this post

Daniel

Hi thank you for your advice I followed it and it worked. I've attached a picture here for you so that you can have a look. What I now need help with is how do I pass the answers to draw data from the database?

Thank you.

Sign in to reply to this post

Ray BorduinWebAssist

When you submit the form the values will be submitted to the action page specified in the form.

Then you can use that information to filter the database by using the DataAssist Search server behavior that comes with Data Bridge.

Sign in to reply to this post

Daniel

What I did was:
I created the dynamic dropdowns and then I created a form but when I opened the 'DataAssist Search' it only gives me the ability to choose from one recordset and I have 5.

Can you please explain to me how to do this?

Thank you.
Daniel.

Sign in to reply to this post

Ray BorduinWebAssist

You are trying to draw data from 5 tables based on the 5 selections? In that case you don't need to use Database Search. Just when you create the recordsets you can use the Simple view and choose to filter the recordset column with a form value and type in the associated form element name from the previous page.

Sign in to reply to this post

Daniel

There are 5 tables and each table has a Primary Key. Some of the tables has a foreign - Then with the selection that has been made I want to draw data from a single table. But I don't know how to get the values from the form to pass them to the recordset query in order for the data to display from the database table.

Sign in to reply to this post

Ray BorduinWebAssist

You use JOIN statements to join all of the tables into a single recordset. Then you can either use parameters in your recordset or DataAssist Search in order to filter the results.

Get the unfiltered results showing from a single recordset first, then add the filter.

Sign in to reply to this post

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