I'm with Dave... The connection persists for the length of the request. I
wonder however about scoping and components. For example, what if I did the
following:
1) createobject("component","com.dbObj").createTempTable()
2)
createobject("component","com.dbObj").getDataFromTempTable(firstname='Bob');
Could the second instantiation of the object result in the use of a
different connection? Since the scope is sort of agnostic of the request I
wonder if that would be the case. It might be interesting to find out.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 12:09 AM
To: CF-Talk
Subject: RE: CF and SQL Server temporary tables
> It's entirely possible for a CF page to change connections in the
> middle of processing a request, and therefore lose sight of the temp
> table.
Actually, I don't think that's possible. My understanding is that a
connection used by a page is retained by the page for the duration of its
execution.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/
WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
