
September 3rd, 2005, 08:22 AM
|
|
Contributing User
|
|
Join Date: Aug 2005
Posts: 39
Time spent in forums: 12 h 33 m 32 sec
Reputation Power: 4
|
|
|
changing vbscript dropdown menu
I'm trying to change a drop down menu on my web site, I have a search page for all items on my web site which use three dropdown menus with info on the items, search by product group, by start character, and by grade.
Here is the code for the menu I want to change.
Code:
strQuery = "SELECT DISTINCT ProductGroup FROM Comics;"
Set objRS = objConn.Execute(strQuery)
dropdown(0) = "<SELECT SIZE=1 NAME=productset>"
dropdown(0) = dropdown(0) & "<OPTION></OPTION>"
While NOT objRS.EOF
dropdown(0) = dropdown(0) & "<OPTION>" & objRS("ProductGroup") & "</OPTION>"
objRS.MoveNext
Wend
dropdown(0) = dropdown(0) & "</SELECT>"
What I want to do is create a page for each group, so I need to be able to set the code to give results of a specific group, instead of giving a dropdown menu with all the groups, I also need to hide the menu.
Thanks for viewing my post
|