Aaron Rouse wrote:
> For updating them it seems like a simple merge query would work fine enough,
> update if exists or it inserts if not. I have a series of custom functions
> I use in the database that help me deal with the need to do things like
> return a list of user permissions from a cross table. So in this case my
> function returns a comma seperated list of permissions, would be the same as
> doing a ValueList() in CF on the query results though.
In my case, the permissions flags are a bunch of checkboxes, so thank to
the way CF handles form inputs, when the form is submitted, they show up
in a single form variable comma separated list and i just insert that
into the database.
And then I handle permission checks like this:
<cfif listFind(qry.permissions,"1")>
...
</cfif>
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235688
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
