New criteria on Security Assist not working
I have Security Assist working based on 'Logged in to users'. Client wants to be able to approve so he can decide who is allowed before they can actually log in (to see the page). So I added a field named 'Approved' that is either 0 or 1 (or true or false) as a tinyint. Now I have to add, through Security Assist, code besides logged in to users that says 'If row on recordset is = to 1 then allow, else don't allow'. What I'm doing is:
1) On the page with the login form I'm clicking 'SecurityAssist Authenticate User' and on the Database Tab I'm adding column 'Approved' and value from $row_Recordset (which I added through DW server behavior).
2) On the Secured page I'm clicking on 'SecurityAssist Restrict Acces to Page I'm going to 'Logged in to Users', editing by adding a new 'Allow if' condition. on Value: I select the $row_Recordset and Compare to 1.
What I'm doing doesn't work. Won't let me in the page. ??