i'm pretty certain it isn't the page ...although the way it is acting would
suggest yes...but i don't think it is
if i run the clearcache.cfm page with timespan(0,0,0,0) the results are
fresh from db
if i then run the proper page with identical SQL but timespan (5,0,0,0) it
brings back cached results! so it is asthough the clearcache.cfm has brought
back fresh results as expected but left a cached set which is still being
picked up
if i then change the timespan on this to (0,0,0,0) the results become fresh
and stay fresh after i change the timespan back to (5,0,0,0)
_______________________________________________________
* 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 27 October 2003 14:08
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Clearing cached queries
provided the query has the same name and all the same SQL, it should be the
same regardless of which page you call it from. which is one of the uses
of cached queries, for queries you repeat on lots of pages.
you sure it's not the *page* that's cached?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Lovelock,
Richard J" To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
<richard.lovelock cc:
@cgey.com> Subject: RE: [ cf-dev ]
Clearing cached queries
27/10/2003 14:02
Please respond to
dev
Ok i don't think i made myself clear enough...
i'll break it down....
i have some pages with cached queries but when i update the DB my pages are
not showing the new data because the results are cached.
To get around this I have been editing all my createtimespan(5,0,0,0) to
createtimespan(0,0,0,0) then uploading all of them and surfing to them and
the pages refresh - magic. Then rechanging all the code to
#CreateTimeSpan(5,0,0,0)# so that the queries are pulled from cache again
(noticeable performance increase)
However this is a bit of a chore, so.......
I have taken all of the cached queries from the various pages and put them
all on to a single page (i.e. clearcache.cfm) but changed all of the
createtimespan(5,0,0,0) to (0,0,0,0). The idea is that after I do all the
DB
updates I can just run this one page to clear all the cached queries.
the page runs ok - and dumping the query results shows that (as you suggest
Rich) the result set is refreshed..wonderful
Then, I go back to my 'proper pages' with the original queries in with
their
createtimespan(5,0,0,0) in hoping that the cache would be cleared and it
would have to rerun the query now and get fresh results but it doesn't
happen and it still appears to bring back cached results - which brings me
to the question I asked:
- does #CreateTimeSpan(0,0,0,0)# (used with cachedwithin) clear any cached
results from cache where all the SQL matches (what I hoped)
OR
- does it retrieve a fresh set of results this one time but still leave the
cached result set in the cache so if you then use #CreateTimeSpan(5,0,0,0)#
it pulls back the old cached results??
(I hope that is clearer)
_______________________________________________________
* 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: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 27 October 2003 13:50
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Clearing cached queries
#createtimespan(0,0,0,0)# will refresh a query that is currently cached and
has the same name and query statement.
> -----Original Message-----
> From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
> Sent: 27 October 2003 13:46
> To: 'cflist'
> Subject: [ cf-dev ] Clearing cached queries
>
>
> Does #CreateTimeSpan(0,0,0,0)# clear any identical cached
> versions of the query from the cache OR does it retreive the
> results fresh for this instance of the query but still leave
> the cached version in the cache - i.e. so if another page
> used the same query but with #CreateTimeSpan(5,0,0,0)# it
> would pick up a cached version even though the query has been
> run from a different page with #CreateTimeSpan(0,0,0,0)# ??
>
> I hope I have made that clear enough
>
> _______________________________________________________<?xml:namespace
> prefix = o ns = "urn:schemas-microsoft-com:office:office" />
>
> * Regards,
> Richard Lovelock
>
> Westminster City Council - Web Support
> Cap Gemini Ernst & Young
> Southbank
> 95 Wandsworth Road
> London
> SW8 2HG
>
> ( 0870 906 7482
>
> _______________________________________________________
>
>
>
>
> =======================================================
> 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]
=======================================================
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]
--
** 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]
