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 ______________________________________________________________________ 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
