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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
