and yes I did actually close the CFLOOP properly in my real code ;-) 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: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 5:00 PM Subject: looping inside cfquery - brain on vacation > 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
