Re: looping inside cfquery - brain on vacation
Maybe this? Loop around the cfquery
cfloop query=theQuery
cfquery name=blah datasource=blah
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
/cfquery
/cfloop
Just out of interest, does anyone know the performance
issues between looping round inside cfquery to insert
multiple records, and looping round *outside*, running
the cfquery tag multiple times?
I didn't know you *could* stick one SQL statement
after another inside cfquery 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
Just tested it, 1000 INSERTS, SQL Server 7.0, both ways
2584 milliseconds as
CFLOOP FROM=1 TO=1000 INDEX=i
CFQUERY NAME=q_addNewAttributeList
DATASOURCE=#request.DSN#
USERNAME=#x#
PASSWORD=#y#
INSERT INTO dbo.vehicleSelection
(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES (13,
11,
'2',
'3',
30,
345678)
/CFQUERY
/CFLOOP
and
991 milliseconds as
CFQUERY NAME=q_addNewAttributeList
DATASOURCE=#request.DSN#
USERNAME=#x#
PASSWORD=#y#
CFLOOP FROM=1 TO=1000 INDEX=i
INSERT INTO dbo.vehicleSelection
(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES (13,
11,
'2',
'3',
30,
345678)
/CFLOOP
/CFQUERY
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 cfquery
cfloop query=theQuery
cfquery name=blah datasource=blah
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
/cfquery
/cfloop
Just out of interest, does anyone know the performance
issues between looping round inside cfquery to insert
multiple records, and looping round *outside*, running
the cfquery tag multiple times?
I didn't know you *could* stick one SQL statement
after another inside cfquery 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
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
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 ;-) 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
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 ;-) 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
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 ;-) 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 __ 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 cfquery tags and output the loop to the screen surrounded with xmp/xmp 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 ;-) 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 __ 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 ;-) 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
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 ;-) 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 __ 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
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 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 ;-) 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
Re: looping inside cfquery - brain on vacation
Thanks Jamesthat xmp/xmp 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 cfquery tags and output the loop to the screen surrounded with xmp/xmp 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 ;-) 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
RE: looping inside cfquery - brain on vacation
Is there any reason your cfloop is inside the cfquery 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 ;-) cfquery name=blah datasource=blah cfloop query=theQuery INSERT INTO Table ( Field ) VALUES ( '#FieldValue#' ) cfloop /cfquery __ 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 cfquery
cfloop query=theQuery
cfquery name=blah datasource=blah
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
/cfquery
/cfloop
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 ;-)
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
__
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
