This topic is locked

Initial Records

6/8/2004 10:25:25 AM
ASPRunnerPro General questions
author

Hi, I know there is an option to show no records on the first page but I did not select this option.
I have made some changes to the files so I do not want to run ASPRunner again.
Is there some code adjustment I can make? Or it's just easier to run the program again?
Thanks.

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


I hope this helps.

500129 6/14/2004

Saved me alot of work editing. Thanks it work perfect.