Hmm,
Wasn't aware the serializable was default in a cftransaction, but my problem or query on this is that I use a try/catch on the outside of this just for general error handling anyway. What I was hoping for was that if I was to use another isolate method instead of serializable, would the @@identiy be better than a separate query for the same reason you describe and not return the wrong ID, I would assume that it only returns the id in that query as it is just the one query? Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485 - Fax: 03 9699 7976 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Thursday, 29 July 2004 10:50 AM To: CFAussie Mailing List Subject: [cfaussie] RE: CFTransaction and CFC's I personally can't see any problems with using <cftransaction isolation="SERIALIZABLE"> apart from slowing things by cueing the threads. Besides, it's the default setting if you don't specify the isolation mode (as of CFMX) [Much Deleted] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
