Thanks, I'll try that. As for the question about the trim ... I had already tried it both ways. Trim was after it didn't work without.
H. > -----Original Message----- > From: Bryan Stevenson [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 5:19 PM > To: CF-Talk > Subject: Re: Delete query that doesn't delete (inside a loop) > > BTW do the loop inside the CFQUERY tags....much faster...don't have to > open > and close the connection for each loop > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Owens, Howard" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 04, 2002 5:04 PM > 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
