Is it possible to just run the one query then output using cfmail? <cfmail query="myQuery" to="" from="" subject="">
-----Original Message----- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 3:18 AM To: CF-Talk Subject: Re: Cfmail performance comparisons "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 fusionauthority.com/bkinfo.cfm AVIS IMPORTANT: ------------------------------- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: ------------------------------- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
