Skip to main content
Inspiring
June 30, 2007
Question

DW8 - multiple search variables

am relative newcomer to ASP-VB and using Dreamweaver.

working on a dating agency site in Dreamweaver (ASP-VB). need multiple search criteria via drop down boxes i.e. age = AND hair colour = AND eye colour + etc.

all working fine passing variables to searchresult page with all known variables listed in each drop down (i.e. hair options = brown, black, blonde etc),

but

i need to add an option into each drop down box to specify "ANY". i.e if someone doesnt want to specify a hair colour it passes a variable which tells the dbase to retrieve everything for that field. otherwise users are forced into having to select a single criteria for each field.

guess ther must be something i can enter in the labels/values for this option to work - can anyone advise. very much appreciated.

code is attached (tho code for my ALL option is obviously haywire!)
This topic is closed to new replies. Start a new post to keep the conversation going.

4 replies

July 3, 2007
Thats a neat way around it, glad you got it working.
Translate
russelliAuthor
Inspiring
July 3, 2007
yep. i added an initial label of "any" and value "%" and sql picks this up fine and all working ok. thanks for replying.
Translate
July 3, 2007
You need to use conditional SQL or Dynamically build your SQL statement.
Translate
Inspiring
July 2, 2007
how about having 'any' and the default choice


--

Translate