Does it work without the trim? Try WHERE email='#i#'
-----Original Message-----
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 8:04 PM
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
