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 );
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, 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?
> 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 default MS SQL Server drivers provided with CF 5 and prior...
You can use a select statement to insert data from a query into another
table, although I'm guessing that this is for your "enterprise manager" app
you were talking about earlier today, so I'd say your best bet is probably
multiple cfqeuries...
S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
