Dave,
Thanks for the info. Any sources you can refer me to where I can dig
into this in greater detail?
Dave Watts wrote:
>
> Whether you use CFINSERT or a regular SQL INSERT statement within CFQUERY,
> you can only update one table at a time. If you need to update multiple
> tables, you'll need multiple inserts. Whether or not they need to be within
> a CFTRANSACTION really depends on the specific circumstances. If they both
> absolutely have to either succeed or fail together, then they belong within
> a transaction.
>
> Yes, if you want to perform multiple inserts within a child table, you'll
> probably end up looping over an insert into that table. There are
> alternatives, but they require a decent amount of SQL within a stored
> procedure.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.