Dave Watts wrote: >> You have to put it in a transaction to make sure you keep >> using the same connection, but you can also persist temp >> tables, savepoints and probably a few more. > > I was under the impression that connections are reused within the same page > already, and released only when the page has finished.
For CFML that is the current behaviour. But it is implicit behaviour, not documented behaviour you can rely on. And IIRC BlueDragon will return connections to the pool between queries on one page. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
