On Thu, Apr 17, 2008 at 8:38 AM, James Smith <[EMAIL PROTECTED]> wrote:
> If I remember correctly if you have CF maintaining connections your > temp table will hang around almost indefinitely, best practice would > be to DROP it once you are done with it. > > > Well I did some tests... and I determined that the table *DOES* get deleted at the end of the request... that's good. Basically I ran a query that created a temp table, then I ran another request that selected from that temp table and it wasn't there .. so either it got deleted at the end of the request, *OR* the second request was a separate "session" and thus CF couldn't see the original temp table. Either way, that's good. rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
