Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
How to stop the search advance from not returning any result if the search criteria are empty. I have found this for simple search:QUOTE if request.querystring("a")="search" and request.querystring("SearchFor")="" thenstrWhereClause = whereAdd(strWhereClause,"1=0")end ifI tried this but it didn't work for the advance search.Thanks in Advance for your support.
Hi,here is a sample:
if request.querystring("a")="advsearch" and session("TableName_asearchfor")("FieldName")="" then