theObjectGateway.deleteByFields(userId=#theid#) _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derek P. Sent: Saturday, December 09, 2006 9:28 PM To: [email protected] Subject: [Reactor for CF] Delete with gateway? Hey everyone!! So, I finally got cfcdoc workin on my reactor folder so I can spy on some of the inner workings.but I haven't been able to find an answer to this question. I need to be able to delete all the records in a table where they have a specific userId.in sql it would look like this: DELETE from userPermissionJoin WHERE UserId = 2 That would delete all the permissionJoin's that are attached to that specific user account.my first instinct was to use a gateway of some kind because This effects multiple records.but I don't know what to do from there.. Any advice friends?? Thanks for the help!! Hope everyone is having a great weekend! - Derek
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
