Oh nevermind, your not looping over the columns of the query (long day as well)
I think you need a semi-colon at the end of your query, since that will put multiple inserts in one cfquery. ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 8:02 PM To: CF-Talk Subject: RE: looping inside cfquery - brain on vacation Hmmm, well if one of your fields is numeric, then that wouldn't work, since numeric values don't need 's around them, you could use the isNumeric() function for that. ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 8:01 PM To: CF-Talk 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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists