|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
something about dropdown box and search |
|
From: |
Brandon |
|
Date: |
9/14/2001 11:44:26 PM |
|
IP: |
128.250.6.245 |
This is how I create dropdown box(search.asp):
<td>
<select name="search_state" size="1">
<option>ANY</option>
<option>ACT</option>
<option>NSW</option>
</select>
</td>
This is how I list out result(search_results.asp):
<%
DIM dataRS, SQLtext
Set dataRS = Server.CreateObjec("ADODB.Recordset")
SQLtext ="SELECT * from Researcher where State ='" & Request.Form("search_state") & "' order by Surname "
set dataRS = mydb.Execute(SQLtext)
%>
<%
do while not dataRS.EOF
response.write "<tr><td><b>" & dataRS("FirstName") & " " & dataRS("Surname") </td>"
response.write "</tr>"
dataRS.moveNext
loop
%>
Question:
If I want to list out everyone in every single state(i.e. ACT + NSW) when user chose 'ANY' in the dropdown box, what can I do to achieve that?
thanks |
Follow Up - Re: something about dropdown box and search - Atahualpa 9/17/2001 8:00:36 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
