I'm trying to limit the results of the list page in my app to only show records that match the logged on user.
on the List page event> "List page:before sql query" i've added the following code....
"strWhereClause=assigneeUID=(Right(Session("USERID"),8))"
the assignee field contains the user's logon name minus the domain. example:rgrahamj. which is my UserID. my session("userid")= "US\rgrahamj". i have two records in my table. record1 assigneeUID="rgrahamj" and record2 assigneeUID="mparker". i'm still seeing both records on the list page. what's wrong with the code?
thanks,
Ray
