2. ASPRunnerPro General questions
  3. Prevent a record from being shown in list view
This topic is locked

Prevent a record from being shown in list view

 		3/3/2009 7:33:16 AM
ASPRunnerPro General questions
A
 alfabravo author

Hi,
Is it possible to prevent a record from being shown in the list view, based on the value of a specific field. For example we have a table for members... if a member status is set to disabled then we dont really want it being shown in the list view, but would like to be able to see it in the search's.
Is this possible?
Many thanks.
J
 		Jane 3/3/2009

Hi,
use List page: Before SQL query event on theEvents tab for this purpose.

Here is just a sample:

if request.querystring("a")<>"search" then

strWhereClause = whereAdd(strWhereClause,"status<>""disabled""")

end if
A
 		alfabravo author 3/3/2009

Hi,

use List page: Before SQL query event on theEvents tab for this purpose.

Here is just a sample:


Tahnks for your help Jane