I have an SP that I use for dealing with inserts of lists. It essentially would do something like this:
INSERT INTO LKP_CATS (PID, CATID) SELECT #PID# PID, CATID FROM CATEGORIES WHERE CATID IN (#MyCatList#) On 3/17/06, Rick Root <[EMAIL PROTECTED]> wrote: > > 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:235691 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
