If TRANSACTION ISOLATION LEVEL is a connection/session level variable, then you'll have to reset it to REPEATABLE READ after you use it, because the DB server doesn't have any knowledge about individual page requests that CF processes. Resetting it after the query doens't have any downside other than the extra typing and the possibility that you might forget.
--- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: jon hall [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 29, 2003 12:57 PM > To: CF-Talk > Subject: setting sql isolation levels within cfquery > > > When setting the an isolation level on a transaction within a > cfquery block affect future queries on the same connection? This > page seems a bit contradictory on the subject. > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/t > sqlref/ts_set-set_74bw.asp > > If so, should I just reset the isolation level to REPEATABLE READ at > the end of the query? Any potential downsides to this? > > <cfquery datasource="#this.dsn#" name="nextEst"> > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE > BEGIN TRANSACTION > SELECT * FROM ... > COMMIT TRANSACTION > SET TRANSACTION ISOLATION LEVEL REPEATABLE READ > </cfquery> > > The thing I want to avoid is having a connection in the connection > pool stuck on SERIALIZABLE... > -- > jon > mailto:[EMAIL PROTECTED] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
