2. ASPRunnerPro General questions
  3. Filter Based on Session Variable
This topic is locked

Filter Based on Session Variable

 		2/5/2009 7:45:14 PM
ASPRunnerPro General questions
author

Hi,
I try to do my homework before I ask for help, but I am stumped. I have set a session variable upon login that I would like to serve as a filter for the list pages.
For example, upon login session(companyID) is set to '4'. Upon opening page products_list.asp I would like to use the session ID to filter the table only for those products with a companyID equal to '4'. In the past, I have handled this on the db end, but am no longer able to do so.
Thank you!!!
J
 		Jane 2/6/2009

Hi,
to filter records on the list page use List page: Before SQL query event on the Events tab.

Here is a sample:

if session("companyID")<>"" then

strWhereClause = whereAdd(strWhereClause,"companyID=" & session("companyID"))

end if