close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dependent select list

Thread began 11/04/2009 6:19 am by Sailors | Last modified 5/13/2013 11:14 am by Jason Byrnes | 2509 views | 5 replies |

Sailors

Dependent select list

Hi All,

Please is it possible to set up dependent select list between two fields that get their values from the recordset? E.g the values of "State" will be dependent on the selected value of "Country".

Please what are the steps if possible.

Cheers.

Sign in to reply to this post

Jason ByrnesWebAssist

use Dynamic Drop Downs


You should have 2 tables:
Country:
CountryID - Primarykey
CountryName

states:
stateID - primary key
stateCountryID - foreign key to country.countryID
stateName


for the parent list create a recordset:
SELECT * FROM Country

Set the list to be dynamic. In the dynamic properties for the list, set the value to the CountryID column, and the label to the CountryName column.

Create a recordset for the states:
SELECT * FROM states

The add a Create Dynamic Array server behavior to the page, set the parent ID to the stateCountryID, set the Child ID to the stateID, set the child name to the stateName column.


now, in design view, select the parent list, on the behaviors panel click the plus button and select Dynamic Drop downs -> Populate List From Array

Set the parent list to the country list and the child list to the state list.

Sign in to reply to this post

danielsebas

Thank you Jason this si really clear on how to achieve it, but when you are in a registration page with captcha and you didn't insert the right captcha value when you press submit the form doesn't clears and tells you the value is wrong, but your selections in the lists clears. How can you make the lists not to clear?
Thank you in advance

Sign in to reply to this post

Jason ByrnesWebAssist

On the body tag, use the set selected in list behavior with the Validated entries binding on the Onload event, also add a populate list from array behavior.

the idea is to use the set selected in list for the parent list, a populate list from array behavior to populate the child list, then a set selected behavior to make the selection in the child list.

Sign in to reply to this post

danielsebas

Hi Jason, I don't understand how to do it.
I accomplished to do a dependent select list, what I want to do is: when I submit the form and the form doesn't pass the server validation, all of the form entries stay in the form so you have to correct only the field you inserted wrong, I can accomplish this with all the items in the form, but the only ones that doesn't retain their input values are the ones of the dependent select list. I am using a dependent list on countries and states.
Thank you for your help.

Sign in to reply to this post

Jason ByrnesWebAssist

in the tag selector, select the body tag.

on the Behaviors panel, click the plus button and select WebAssist -> WA Dynamic DropDowns -> Set Selected In List.

For the target list, select the parent list.

For the value, click the lightning bolt icon and select the corresponding element from the Validated Entries Collection.

click the plus button again, this time select WebAssist -> WA Dynamic DropDowns -> Populate List from Array. and set up the dynamic array the same as you did for the onchange event of the parent select list.

click the plus button once more and select WebAssist -> WA Dynamic DropDowns -> Set Selected In List.

For the target list, select the child list.

For the value, click the lightning bolt icon and select the corresponding element from the Validated Entries Collection.

make sure these 3 behaviors are added to the onload event of the body tag.

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