Search not working after running a beforeSQLquery event

This topic is locked

Search not working after running a beforeSQLquery event	10/27/2008 8:59:45 PM
ASPRunnerPro General questions
G gpsit author Hi - I have built a before SQL query event to show only records that are like a particular login on my list pages as the Advanced security permissions does not work in my case as it returns records that equal the ownerID whereas I need it to return records that are LIKE %OwnerID%. This works perfectly, however if I try to search on the list page nothing happens!, I assume this is due to the beforeSQLquery event that I have already run. How do I get the search function to work again? Many thanks in advance


G	gpsit author 10/29/2008
	I have figured out a workaround by editing the .....Variables.asp code to include a WHERE clause based on a session variable. However it means have to update this for each list page I want to control access to. I also manually edit the login.asp code to capture more user based session variables to use in these pages as well If there is a way to set security permissions to a LIKE not = statement it would eliminate this I guess? has anyone figured out how to do this? Cheers