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
4 matches
Mail list logo