complex search

[aamaker]

Im trying to build a 'search' feature similar to whats found at the following URL:

http://www.charlotteusa.com/Sites/sites_search.asp

Question I have is if this can even be built with DW8 using the built-in server behavior dialogue where you use a database connection to build a record set... or would one need to hand code the programming (in this case, asp) to pull this sort of search off because of the varying search criteria / options?

I mean there are so many options - what if the user leaves option 1 empty (i.e. elects NOT To filter by that piece of data)... what would the recordset be using to 'match' against... some sort of 'return all' seems to be the key, and I know somehow the % character can be used but how?

Lastly, where the user selects from the list of counties (near the bottom) ... how is that done in terms of writing / organizing the code to process the search?

Thanks for any light you all can shed on this for me.

 

[Cheech]

Switch your recordset view to advanced you will then be able to incorporate as many search criterea as you wish. Each variable would have the runtime value of Request.Form blah blah and a default value of %

Cheech

[Peace][Pipe]

 

[aamaker]

Thanks! I am having another issue now though, some of the search criteria is of the number / integer datatype, so the % wildcard doesnt appear to work, is there an equivalent for number values (i.e. something that would equate to "any number" like the % does for text).

 

[Cheech]

Post your sql here giving examples of data

[Peace][Pipe]

 

[aamaker]

I just set the numerical values to either the lowest possible ( 0 ) or some astronomically high number ( 999,999 ) and thats working for me.

But thanks!