Re: looping through a mailing list

2000-03-29 Thread Chris Giminez
I've changed part of the checking to the query, not cfif's, but I am still getting the same wrong results. I could really use some help if someone can, or at least a nudge in the right direction. ***!--- Get the list of subscribers who wich to be notified. --- CFQUERY

Re: looping through a mailing list

2000-03-28 Thread Allen
what's the record count for teh query notify_list? Is it 3 also? - Original Message - From: "Chris Giminez" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 28, 2000 2:13 PM Subject: looping through a mailing list This is for a real estate web site where the realtor will

RE: looping through a mailing list

2000-03-28 Thread Jordon Saardchit
Yer wasting a lot of processing power in coldfusion unnecessarily. You should build a where clause that replicates the conditions you are searchinf for in your CFIF, that way you just loop over the result set and send the email to every single record. SQL Will handle that much faster than Cold