RE: looping inside cfquery - brain on vacation
Those figures don't surprise me, because the cfquery is run once not 1000 times and is a valid query if separated with a ';' -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 February 2002 12:01 AM To: CF-Talk Subject: RE: looping inside cfquery - brain on vacation Just tested it, 1000 INSERTS, SQL Server 7.0, both ways __ 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
RE: looping inside cfquery - brain on vacation
Just tested it, 1000 INSERTS, SQL Server 7.0, both ways
2584 milliseconds as
INSERT INTO dbo.vehicleSelection
(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES (13,
11,
'2',
'3',
30,
345678)
and
991 milliseconds as
INSERT INTO dbo.vehicleSelection
(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES (13,
11,
'2',
'3',
30,
345678)
J
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:42 PM
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation
> Maybe this? Loop around the
>
>
>
> INSERT INTO Table
> (Field)
> VALUES ('#theQuery.FieldValue#')
>
>
Just out of interest, does anyone know the performance
issues between looping round inside to insert
multiple records, and looping round *outside*, running
the tag multiple times?
I didn't know you *could* stick one SQL statement
after another inside until seeing this thread.
Is this more efficient?
- Gyrus
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
__
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
Re: looping inside cfquery - brain on vacation
> Maybe this? Loop around the
>
>
>
> INSERT INTO Table
> (Field)
> VALUES ('#theQuery.FieldValue#')
>
>
Just out of interest, does anyone know the performance
issues between looping round inside to insert
multiple records, and looping round *outside*, running
the tag multiple times?
I didn't know you *could* stick one SQL statement
after another inside until seeing this thread.
Is this more efficient?
- Gyrus
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
__
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
Re: looping inside cfquery - brain on vacation
Maybe this? Loop around the
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
wasgr ;-)
>
>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
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>>
>>
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>
>>
>>
>> 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
>>
>>
>>
>>
>
__
Get Your Own 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=coldfusionb
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
RE: looping inside cfquery - brain on vacation
Is there any reason your is inside the pair and not outside? - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> > 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 > beforejust saw it posted the other week too...geesh talk about > timing ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > __ 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
Re: looping inside cfquery - brain on vacation
Thanks Jamesthat trick worked like a charm! There is one bad record throwing the whole lot. Thanks all for your help ;-) 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: "James Curran" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 5:02 PM Subject: RE: looping inside cfquery - brain on vacation > Are there > > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 8:01 PM > To: CF-Talk > Try taking out the tags and output the loop to the screen > surrounded with > > Then just check your SQL statements... It's usually standing out like a sore > thumb :) > > - j > > > 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 > beforejust saw it posted the other week too...geesh talk about timing > ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > > > 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
RE: looping inside cfquery - brain on vacation
You may have to do the loop on the outside of the query, use a cftransaction to send them all through at once. INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) __ 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 wasgr ;-) 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 > beforejust saw it posted the other week too...geesh talk about > timing ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > > > 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
Re: looping inside cfquery - brain on vacation
dang tried the semi-colon already with no luck...thought that's what it wasgr ;-) 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 > beforejust saw it posted the other week too...geesh talk about > timing ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > > > 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 > > > > __ Get Your Own 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=coldfusionb 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
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 beforejust saw it posted the other week too...geesh talk about timing ;-) INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) 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
Re: looping inside cfquery - brain on vacation
Nope that's not the issue for sure..just used the single quotes as an example..but 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:01 PM 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 > beforejust saw it posted the other week too...geesh talk about > timing ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > > > 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 > > > __ Get Your Own 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=coldfusionb 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
RE: looping inside cfquery - brain on vacation
Are there -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 8:01 PM To: CF-Talk Try taking out the tags and output the loop to the screen surrounded with Then just check your SQL statements... It's usually standing out like a sore thumb :) - j 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 beforejust saw it posted the other week too...geesh talk about timing ;-) INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) 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 __ Get Your Own 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=coldfusionb 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
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 beforejust saw it posted the other week too...geesh talk about timing ;-) INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) 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
Re: looping inside cfquery - brain on vacation
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 > beforejust saw it posted the other week too...geesh talk about timing ;-) > > > > INSERT INTO Table > ( > Field > ) >VALUES > ( > '#FieldValue#' > ) > > > > 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
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 beforejust saw it posted the other week too...geesh talk about timing ;-) INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) 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
