So, why doesn't this work
<cfsetting showdebugoutput="Yes">
<cfloop index="i" list="csv,list,of,bad,email,addresses">
<cfquery
name="DELETEADDRESSES"
datasource="dsn"
blockfactor="100" debug>
DELETE FROM emp_jobs
WHERE email = '#trim(i)#'
</cfquery>
</cfloop>
No error message. The query is good. I can plug in a static e-mail address
and it works. I can run it staticly through Query Analyzer just fine.
But if I run this in a CFTemplate, no records get deleted.
I'm stumped.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
