>Hello all. I am attempting to design a security system for our software.
>I am using the Mere Mortals framework.
>In my design, the administrative user defines what records the normal users should see.
>
>Using a form, the administrator picks options to filter the record set for each user, and I store part of a WHERE statement built from the chosen options in a table for that user. For instance, if the administrator picks that user Betty should only see records in the city of San Franciso. I store (city.cid = " 13") for user Betty.
>
>When Betty logs in , I want to append that last statement on the end of my view. My views are all in code, so I define a vp_filter. On the search form for the view, I set the custom WHERE string into vp_filter.
>In my view, I build the SQL, Select * from where ...
>...
>and ?vp_filter.
>
>I am getting a SQL error on this statement. Should this be a macro expansion instead? e.g. &vp_filter?
>
>Sorry for the long post, I hope what I am trying to do makes sense. (Or is even correct!)
>
>TIA
>Amanda


Amanda,

Try

   and &?vp_filter

Click here to load this message in the networking platform