So how should one write the query to pull 100 messages at the time and set a
flag so they would not be selected the next time
select top 100 id,email from sometable where flag is 0
update sometable set flag = 1 where id in (????)
----- Original Message -----
From: "Victor Chou" <[EMAIL PROTECTED]>
> If the emails aren't extremely time critical, a CF schedule that send them
> in batches of say 100 would do it just fine.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
