> > Is it possible to find how many records were updated in <cfquery>????
> >
>
> Were?
>
> You could calculate the number of records that should be updated by
> running a preliminary query that selects the same set.
>
> To affirm that the selected set was, in fact updated, you'd have to
> test the state of the set before and after update. Select into a
> temp table the set you want to update, run the update against the
> temp table - then compare by record the orignal table and the temp
> table. Proceed to commit the update on the original table or otherwise.
>
> In some rdbms systems a triggered sp or other mechanism might
> write an audit trail to a log ....
It is Ok, but what about performance?
Gennadi
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
