Thanks James....that <xmp></xmp> trick worked like a charm! There is one bad record throwing the whole lot.
Thanks all for your help ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: "James Curran" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 5:02 PM Subject: RE: looping inside cfquery - brain on vacation > Are there > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 8:01 PM > To: CF-Talk > Try taking out the <cfquery> tags and output the loop to the screen > surrounded with <xmp></xmp> > > Then just check your SQL statements... It's usually standing out like a sore > thumb :) > > - j > > > OK..long day..CF whining about syntax...help! > > The situation: > > CF doesn't like my syntax for this bit of looping over a query to insert > muliple records. It's > complaining about the final ")" closing bracket for the insert. Any ideas? > I'm sure I've done it > before....just saw it posted the other week too...geesh talk about timing > ;-) > > <cfquery name="blah" datasource="blah"> > <cfloop query="theQuery"> > INSERT INTO Table > ( > Field > ) > VALUES > ( > '#FieldValue#' > ) > <cfloop> > </cfquery> > > TIA > > Bryan Stevenson > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > p. 250.920.8830 > e. [EMAIL PROTECTED] > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
