Unfortunately I do not have access to the code to look at right now. I know it actually does a MERGE and not the query I typed up earlier. My guess is I actually just wipe out what is in there and then repopulate, that is something I wrote and used well over a year ago so I honestly do not recall. I the current pages I write for lookup information of this sort I am not doing mass insert/updates, so it is not an issue there.
On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>INSERT INTO LKP_CATS > > And how do you remove permissions that were there before and no more in > MyCatList? > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235695 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
