Rob, With pooled connections you can force a request to stay on one connection by wrapping your queries in cftransaction. Otherwise, CF can and will swap connections on you right in the middle of processing a request, and your temp tables will go away.
Jaime > -----Original Message----- > From: Robert Rawlins [mailto:[EMAIL PROTECTED] > Sent: Monday, 11 August 2008 9:01 PM > To: CF-Talk > Subject: RE: Database Sessions > > Thanks James, that makes fair sense, > > I'll check my connection pooling setting and have a play > around, I'll let you know how I get on. > > Rob > > -----Original Message----- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: 11 August 2008 11:55 > To: CF-Talk > Subject: Re: Database Sessions > > CF does conenctions two ways: > > 1) CF uses pooled connections if you have maintain > connections checked for the datasource, This means a > connection will stay open for quite some time, across > multiple web requests. > > 2) If you don't maintain connections, CF opens a connection > at the first cfquery tag and keeps it open until the request > ends, so that all the queries in a single request use the > same connection. > > So, at the very least, you should be able to use your > temporary table for everything in the page. > > On Mon, Aug 11, 2008 at 5:42 PM, Robert Rawlins > <[EMAIL PROTECTED]> wrote: > > Morning guys, > > > > Does anyone know how ColdFusion handles opening and closing > a database > > session? Is it for every cfquery tag set? Or for every > cftransaction > > tag set? Or is it less predictable than that? > > > > The reason I ask is that I've been looking at using > temporary tables > > in a procedure, as I understand it, SQL Server creates these in a > > session local variable. I need to know how long the temporary table > > will be accessible > to > > me in this session scope, can it spread across multiple queries? Or > > just > the > > single one?. > > -- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
