yes I am using (1) - copied and pasted the queries in to a separate file and
changed the creatimespan from 5 to 0.
so theoretically should be identical apart from the timespan - changing this
wouldn't prevent the query being cleared from cache would it - as this is
the whole point of the parameter isn't it? (or am i confused)
_______________________________________________________
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
_______________________________________________________
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 27 October 2003 15:03
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Clearing cached queries
> using a separate
> page consisting of all the queries from my various pages
Have you
- copied and pasted the queries from the other templates into a single
template and adjusted the cachedwithin attribute or
- are you using a cfinclude or cfmodule file which includes or returns
each query that you're caching?
If you are using (1), there's a chance that the queries aren't getting
flushed as they aren't perceived as being identical to the cached ones
by ColdFusion when you run the template where the cachedwithin attribute
is CreateTimeSpan(0, 0, 0, 0).
As someone mentioned, even a difference in whitespace is enough to
prevent the cached query from being flushed -- hence (2) the suggestion
to just have a single section of code that generates and includes or
returns the query.
--
Aidan Whitehall <mailto:[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards>
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
=======================================================
This message contains information that may be privileged or confidential and is the
property of the Cap Gemini Ernst & Young Group. It is intended only for the person to
whom it is addressed. If you are not the intended recipient, youare not authorized to
read, print, retain, copy, disseminate, distribute, or use this message or any part
thereof. If you receive this message in error, please notify the sender immediately
and delete all copies of this message.
=======================================================
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
