Combo Box
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=25378
Printed Date: 29 March 2026 at 3:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Combo Box
Posted By: silverman
Subject: Combo Box
Date Posted: 01 March 2008 at 9:44pm
Hi, I am using asp and I have a combo box which has values such as "JAN", "FEB" etc. What I would like to do is when the user selects "JAN", the page gets posted back into itself and retrieves and displays data from a table in my SQL Database with all the data for "JAN". Then say if the user selects "FEB", the data is pulled out from the DB and displays all the "FEB" info.
I know I have to use an IF ELSE statement and then use a SELECT statement, but just do not know the correct way of doing this! Thanks
|
Replies:
Posted By: Scotty32
Date Posted: 01 March 2008 at 11:01pm
well prob best way to do it would be:
have the dropdown shown all time, to skip to another month, the refresh on selection would be done with javascript, search google for that.
then have
strMonth = request.form("month")
if strMonth <> "" then
select data from table where month = '" & strMonth & ";"
end if |
-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins
For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .
|
|