I'm probably just being silly, but you have turned off the caching of web pages in your web browser hey? ie. It's not just a case of HTML output not being refreshed each time.
-----Original Message----- From: Russ 'Snake' Michaels [mailto:snake@;snakepit.net] Sent: 29 October 2002 15:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] caching queries When caching queries, is it only the query anme query name that needs to be the same, or is it also dependant on the template that called it. for example, I have a custom tag that queries a database with a bunch of passed params, including the cache period. I also called this tag elsewhere from a content editor, and sending a cachedwithin of "0", so effectively it should un-cache the query. But the query seems to remain cached even though I am setting a CreateTimeSpan(0,0,0,0) e.g in the site <CF_SHOWCONTENT cachedwithin="2" container="container1" username="whatever" password="whatever" datasource="whatever"> and form the admin <CF_SHOWCONTENT cachedwithin="0" container="container1" username="whatever" password="whatever" datasource="whatever"> and the query generated is thus <cfquery name="contentItems_#replace(attributes.container,' ','_','ALL')#" datasource="#attributes.DSN#" username="#attributes.username#" password="#attributes.password#" cachedwithin="#CreateTimeSpan(0,attributes.cachedwithin,0,0)#"> select #attributes.rowcount# #attributes.columnlist# from contentItems where containerName = '#attributes.container#' </cfquery> <cfset "caller.#attributes.query#" = evaluate('contentItems_#replace(attributes.container,' ','_','ALL')#')> -- ** 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]
