RE: [Reactor for CF] Delete Where

[João Fernandes]

Brad,   You can use : <cfset gtw = reactorFactory.createGateway(“sometbl”)> <cfset gtw.deleteByFields(theField=2)>   João Fernandes   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Haas Sent: quarta-feira, 16 de Agosto de 2006 16:42 To: reactor@reactorframework.com Subject: [Reactor for CF] Delete Where   I need to delete fields from a table with a where clause:   DELETE FROM SomeTbl WHERE TheField = 2   What is the best way to do this in Reactor. I guess you could create a gateway and use the where method on it to get the record set. Then you could loop through each record one-by-one and do a delete. Is there an more efficient way than this?   Thanks, Brad     -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --