Environment: DreamweaverMX 2004, ASP, VBScript, mySQL
I have a dropdown which is populated dynamically from a mySQL database plus an option "All" that returns all records (value "%").
The problem is that
1) there doesn't seem to be any way in which the dropdown box will display the word "All" by default, perhaps because this is not a value in the database.
2) The word "All" is not displayed in the dropdown box after the the user has chosen it, it reverts to a dynamically drawn word instead.
I can, however, do this if the dropdown is not dynamic, by adding extra code, but this just doesn't work if the selection list is dynamic.
The search and results are carried out on the same page.
Any clues anyone ?