Can you do multiple insert statements in one CFQUERY statement?
ie
cfquery ...
Insert into
Insert Into ...
Insert Into ...
/cfquery
If yes, is there something special that needs to be added?
Thanks
Paul Giesenhagen
QuillDesign
Can you do multiple insert statements in one CFQUERY statement?
ie
cfquery ...
Insert into
Insert Into ...
Insert Into ...
/cfquery
If yes, is there something special that needs to be added?
It probably depends on your drivers, although I've not been able to in the
past with the
I take that back, I was probably remembering using Access about 5 years ago
.. which is probably the last time I tried it. In MS SQL Server you're
probably good if you use the semi-colon on the end of each insert statement.
S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer
, The American Crisis
Let's Roll
- Todd Beamer, Flight 93
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 10:50 AM
To: CF-Talk
Subject: Re: OT: Multiple Inserts
Can you do multiple insert statements in one CFQUERY statement
I agree. I've never found a way to do it in Access, MS SQL, or Oracle.
You
CAN do it with MySQL however since it allows a multiple insert syntax like
so:
INSERT INTO table( columlist )
VALUES( record1 ),
( record2 ),
( record3 ),
( record4 );
That would be so sweet! :-(
S. Isaac
5 matches
Mail list logo