2. ASPRunnerPro General questions
  3. Edited sql statement and advanced search
This topic is locked

Edited sql statement and advanced search

 		8/2/2005 4:53:57 PM
ASPRunnerPro General questions
sparkg author

I edited the sql statement with a WHERE clause to only initially open a table with returned records with ProjectStatus field marked "New" or "Open" - none marked "Closed". This works fine but we want to be able to (and thought we could) see the records marked "Closed" by going to advanced search and searching for "Closed" but it won't return them.

Is it that Runner works always off that one sql statement?

Is there any way to do this?
Thanks!
admin 8/3/2005

Hi,
you need to generate ASP files without WHERE clause. Use "No records on the first page" option on the Choose fields tab in ASPRunner.

Open ..._list.asp file by any text editor, find the following code snippet:

if Request("action")="" then

  strSQL = AddWhere(strSQL, "1=0")

end if


and replace

1=0

with

ProjectStatus<>'Closed'
Now you can see all records with ProjectStatus field marked "New" or "Open" on the first page and also you can search the records marked "Closed".
sparkg author 8/3/2005

That worked like a champ...many thanks Sergey!