select and flag records

[Dirk De Bock]

I have a table with a big number of email addresses. I want to send out mail
in batches of 1000. For this I need to select the top 1000 records where a
flag is false, and then set this flag to true so I won't select them for the
next batch.

Can this be done in one query, maybe with a stored procedure, or do I have
to do this with two queries wrapped in a cftransaction?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists