DW8 - multiple search variables

[russelli]

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!)

[Newsgroup_User]

how about having 'any' and the default choice


--

[Guest]

You need to use conditional SQL or Dynamically build your SQL statement.

[russelli]

yep. i added an initial label of "any" and value "%" and sql picks this up fine and all working ok. thanks for replying.

[Guest]

Thats a neat way around it, glad you got it working.