2. ASPRunnerPro General questions
  3. Opening SQL statement
This topic is locked

Opening SQL statement

 		8/7/2008 11:55:04 AM
ASPRunnerPro General questions
sparkg author

I have a table with a field with drop down values of "open" or "closed" for a record. When the table first opens, I only want to see "open" records. Then when show all or search is done , I want to see open and closed records.

I used to do this in older ASPRunner versions, but can't remember how - not sure how in newest version 5.2.
Thanks all...
sparkg
Sergey Kornilov admin 8/8/2008

Add the following WHERE clause to SQL query (SQL Query tab)

WHERE field='open'
L
 		lyngaaskhan 8/9/2008

Add the following WHERE clause to SQL query (SQL Query tab)


WHERE field='open'


I tried this earlier, but the "show all" button still shows the record set with the where clause - in other words, 'show all' still shows open records only.

In the end, I used some conditional processing in the Before SQL query event to implement this functionality.