You may have to do the loop on the outside of the query, use a
cftransaction to send them all through at once.
<cftransaction>
<cfloop query="theQuery">
<cfquery name="blah" datasource="blah">
INSERT INTO Table
(
Field
)
VALUES
(
'#FieldValue#'
)
</cfquery>
</cfloop>
</cftransaction>
______________________
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 8:16 PM
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation
dang tried the semi-colon already with no luck...thought that's what it
was....grrrrrrrrr ;-)
Thanks
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: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation
> 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
>
>
>
>
______________________________________________________________________
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
