[Reactor for CF] Delete Where

[Brad Haas]

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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --