I'm guessing here, but there's a dirty little secret about debug messages that I'll let you in on - insert, update and delete operations always show (Records = 0 ...). Check the database. I'll bet you're chasing geeese and the inserts, deletes and updates are working. Too bad I've never seen this posted or documented...
- Chuck McElwee Certifed Advanced ColdFusion Developer -----Original Message----- 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. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
