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
',
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
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
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
: 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
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
, 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
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
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
, 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
: 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
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
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
://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
14 matches
Mail list logo