John,

Other might have a better solution, but I would recommend to add a custom method to the Gateway object.

HTH

Qasim

On 11/6/06, John Blayter <[EMAIL PROTECTED]> wrote:
I am just curious on if there is a simple way to update multiple
records at the same time using reactor like the query below.

UPDATE MyTable
SET IsActive = 0
WHERE ExpireDate < #CreateODBCDateTime(Now())#

Thanks,

John


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

Reply via email to