"Stacy Young" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED] merce.com>... > Are u processing anything else besides outputting a query into cfmail?
Yes. I'll probably loop over the cfmail, and run a query each time. I'm coming round to thinking the best, most reliable way to do it would be to create a scheduled task which would: A) grab 100 records at a time, store the range (0-100, 2300-2400 etc) in another table B) Loop over this and process the mail C) Run this every 5/x minutes, taking the last biggest range (i.e. 100-200, 200-300). I can't see how else to do it really. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
