<font face='Verdana'>
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 the fist value in the recordset 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????

Lesley</font id='Verdana'>

Hi,

Normally when you create a dropdown menu, you have the option to add static or dynamic values, when you add a static value (for you % All option) this will be the default selection and then below this the dynamic options.

can you post the code with your menu in it so i can see if I can see what is going on?

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

Hi Vince, it's all ok now I've put a Request("formobjectname" in the dynamic value field, and added the All "%" value.

Many thanks for your input,

Lesley