Re: OT: Multiple Inserts

2002-09-20 Thread S . Isaac Dealey
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

Re: OT: Multiple Inserts

2002-09-20 Thread S . Isaac Dealey
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

RE: OT: Multiple Inserts

2002-09-20 Thread Bryan Love
, 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

RE: OT: Multiple Inserts

2002-09-20 Thread S . Isaac Dealey
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