You might want to try outputting the #email# variable inside your loop like so: <cfloop query="email_list"> e-mail variable is: #email#<br> <cfmail to="#email#" from="[EMAIL PROTECTED]" subject="subject" mimeattach="H:\www_02\serverdir\file.gif">
This will at least tell you what the value(s) are. You may get 2 lines (giving the same info Dylan was asking about) or you may find that you have a ; delimited list in #email#. Either way, it should be helpful info HTH Stephen -----Original Message----- From: Dylan Bromby [mailto:dylan@;bromby.com] Sent: Thursday, October 24, 2002 9:26 AM To: CF-Server Subject: RE: CF-Server-List V1 #129 What's the recordcount on the email_list query and how many total records are in the EmailsToGo table? -----Original Message----- From: Morgan Work [mailto:morgan@;amnesia.com.au] Sent: Wednesday, October 23, 2002 9:47 PM To: CF-Server Subject: Re: CF-Server-List V1 #129 This is the code I used <!-- <cfquery name="email_list" datasource="DSN"> select * from EmailsToGo </cfquery> <html> <head> <title>Mail Loop</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <cfloop query="email_list"> <cfmail to="#email#" from="[EMAIL PROTECTED]" subject="subject" mimeattach="H:\www_02\serverdir\file.gif"> . </cfmail> <cfoutput> #email#<BR> </cfoutput> </cfloop> </body> </html> --> ----- Original Message ----- From: "CF-Server" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 2:24 PM Subject: CF-Server-List V1 #129 > CF-Server-List Thu, 24 Oct 2002 Volume 1 : Number 129 > > In this issue: > > Re: CF-Server-List V1 #128 > RE: CF-Server-List V1 #128 > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
