|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
