![]() |
Sergey Kornilov admin 6/8/2004 |
You can edit ..._list.asp file for this purpose (see my changes in bold): ' advanced search if Request.Form("action")="AdvancedSearch" then sWhere="" For i = 1 To Request.Form("SearchFor").Count strSearchFor=Trim(Request.Form("SearchFor")(i)) strSearchFor2=Trim(Request.Form("SearchFor2")(i)) if strSearchFor<>"" then if sWhere="" then sWhere=" where 1=1" strSearchOption=Trim(Request.Form("SearchOption")(i))   sWhere = sWhere & " and " & AddWrappers(Request.Form("FieldName")(i)) & StrWhere(Request.Form("FieldName")(i), strSearchFor, strSearchOption, strSearchFor2) end if next strSQL = strSQL & sWhere end if if Request.Form("action")="" then  strSQL = strSQL & " where 1=0" end if strSQL = strSQL & " " & Trim(strOrderBy) end if
|
|
500129 6/14/2004 |
Saved me alot of work editing. Thanks it work perfect. |