DYNAMIC Dropdown. How to stick on non dynamic choice?

[Lesley G]

Environment: DreamweaverMX 2004, ASP, VBScript, mySQL I have a dropdown which
is populated dynamically from a mySQL database plus a hand entered option 'All'
that returns all records (value '%'). The problem is that there doesn't seem
to be any way in which the dropdown will display 'All' by default or stick on
this choice, once made by the user. 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???? Lesley

[Piers 2k]

Lesley,
Select the list/menu and go into code view and look for the following:
<select name="select">
<%
While (NOT rstRecordset.EOF)
%>
........
On the line below <select name="select">, enter
<option value="%">-- All --</option>

I don't know if a % is the wildcard character for mySQL, so might need to
change that around.

Let me know,
Piers

[greekchild]

Hi Lesley, I had this problem too that when someone selected an item from a
dropdownlist and the form was submitted, the results would show in the
recordset but the item they selected from the dropdown would change. I have
the results on the same page too and am using a URL paramater. In the dynamic
list/menu properties there is an option of setting 'select value equal to' In
there put in <%= Request.Querystring('nameofdropdownlist') %> If your not
using URL parameters substitue the Request.Querystring with Request.Form Hope
that helps

[Lesley G]

Thanks BIGTIME guys, at last, it's working !!

Where would we be without forums eh?

Thanks again,

Lesley