RE: cfquery vs. cftransaction

2000-04-07 Thread Jordon Saardchit
Best way to do it would be in a Stored Procedure, wrapped in a SQL transaction. -J -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 7:56 AM To: Cf-Talk@Houseoffusion. Com Subject: cfquery vs. cftransaction Let me try this again please. Is

Re: cfquery vs. cftransaction

2000-04-07 Thread Bud
On 4/7/00, Jim Taylor penned: Let me try this again please. Is this the best way to handle a 2 table insert ? The main reason to run a cftransaction is if the results from one query are going effect the entry into another. For instance: 1. Someone places and order and the order is written to