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. > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
