Wrap your cfmail statement in a recordcount test <cfif sendnewsletter.recortcount lt 1> uh oh<cfabort> <cfelse> <cfoutput>#sendnewsletter.email#<cfoutput><cfabort> </cfif>
The first block will isolate whether you have a problem with your query syntax. The second will output the email address, if one is being returned, so you can debug the thing. The cfaborts will keep the output down to size for now. You may also want to output the primary key value so you know which record is causing the problem. Hope this helps, -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138288 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
