This topic is locked

Advanced search criteria

9/4/2005 11:09:24 AM
ASPRunnerPro General questions
author

Is there any way to only have one search criteria per each database field in the advanced search page.
Eg. ID name "equals to"

Age "greater than" etc
The help will be most appreciated.
thanks

Sergey Kornilov admin 9/5/2005

Hi,
you can replace call to WriteSearchOptionsfunction with actual option values list. To do this you need to modify generated ..._search.asp file.

501241 9/5/2005

How you assign each option to each field???????????

Sergey Kornilov admin 9/5/2005

You need to modify search.asp page the following way. Find the following code section for each field:

call WriteSearchOptions(GetEditFormat("FieldName"), Session("SearchOption_" & strTableName & "_FieldName"))


Replace it with one of the following.
To search as Equals:

Response.Write "<input type=hidden ID=""SearchOption"" NAME=""SearchOption"" value=""Equals"">"


To search as Contains:

Response.Write "<input type=hidden ID=""SearchOption"" NAME=""SearchOption"" value=""Contains"">"


etc.

501242 9/6/2005

Thanks...........that's great.