Do the loop without trying to delete from the DB, see what it is that's getting passed to cfquery, so you can see i
I know the default delimiter is the comma, but try specifying it anyway Ade -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 01:04 To: CF-Talk Subject: Delete query that doesn't delete (inside a loop) 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. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
