i'll keep this in mind when they upgrade to MX.. still running 5 right now.





Jochem van Dieten <[EMAIL PROTECTED]> on 07/31/2002 08:54:50 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Community <[EMAIL PROTECTED]>
cc:    (bcc: Scott Raley/LPEC/ASD/SEMCORINC)

Subject:  Re: Force Query



Scott Raley wrote:
> Is there any way that I can force a template or the query in a template to be
> rerun and not be cached by CF SErver from the client side?  I believe this is
> the root of my display problems because I can connect directly to the db
through
> a sql client and all queries from the templates work fine. Running the actual
> templates gives sporadic data.

In CF MX you should be able to purge the entire cache using the code
below (but for a single query Philips code is probably better):

<cflock name="serviceFactory" type="exclusive" timeout="10">
     <cfobject action="create" type="java"
class="coldfusion.server.ServiceFactory" name="factory"/>
     <cfset factory.datasourceservice.purgeQueryCache()/>
</cflock>

Jochem


______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to