hi guys...i have done a drop down tht gets its data from the database(SQL SErver) and
i am using ASP. the problem is tht i am unable to filter according to data in drop
down...for example....went the client selects Germany from the drop down list...it
should display output tht has the word germany in it........below is my code and
figure....
<select name = "Selsite" >
<
set oRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT DISTINCT Site FROM APPLICATION "
strSQL = strSQL & "ORDER BY Site"
oRs.Open strSQL, conn
Do while not oRs.EOF
if Request.Form("Sites") = oRs("Site") then
'Response.Write "<OPTION VALUE = '" & oRS ("Site") & "'Value>"
Response.Write "<OPTION VALUE = '" & oRS ("Site") & "'SELECTED>"
Response.Write oRs("Site") & "</Option>"
oRs.MoveNext
else
Response.Write "<OPTION VALUE = '" & oRs ("Site") & "'>"
Response.Write oRs("Site") & "</Option>"
oRs.MoveNext
end if
loop
%>
</select>
thanks for any help.....
---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
