i assume you mean this for each page request. OpenBD by default doesn't hold a connection for the duration of the page, as this is somewhat inefficient and blocks other pages from utilising the inherent overlapping that comes with processing pages.
However you can do a couple of things to make OpenBD use the same connection throughout. 1. <cftransaction> around the block 2. [Andy is now about to email the list and tell you!] :) On 10/11/2008 13:37, Victor Balada Diaz wrote: > seems ColdFusion does use persistent connections for MySQL and > OpenBD isn't. This prevents you from using temporary tables, as > they're created and destroyed in the same query. > > Is there any way to make OpenBSD use persistent connections? --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
