ooo. its the little things that kick you in the nuts sometimes ain't it! > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:snake@;snakepit.net] > Sent: 29 October 2002 15:59 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] caching queries > > > OK query names are case sensitive :-) > > > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:snake@;snakepit.net] > Sent: 29 October 2002 15:38 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] caching queries > > > no cozz unless I pass attributes to cause the content to > change, the only > thing that changes is the query name and cached within, which > are set the > same in both calls. > > > -----Original Message----- > From: Rich Wild [mailto:r.wild@;e-mango.com] > Sent: 29 October 2002 15:26 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] caching queries > > > sorry, what I'm trying to get at is: is it possible you are > changing the > statement between the two calls of <cf_showcontent>? > > > -----Original Message----- > > From: Rich Wild [mailto:r.wild@;e-mango.com] > > Sent: 29 October 2002 15:20 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] caching queries > > > > > > its not the template, its a) the name of the query and b) the > > contents (ie > > the actual statement) > > > > if the statement is different then its treated as a different query. > > > > The following code proves this... > > > > <cfscript> > > myquery = querynew("col1"); > > for(i=1;i lte 10;i=i+1) { > > queryaddrow(myquery); > > querysetcell(myquery, "col1", i); > > } > > </cfscript> > > > > <cfquery name="testquery" dbtype="query" > > cachedwithin="#createtimespan(0,1,0,0)#"> > > SELECT col1 FROM myquery WHERE col1 <= 5 > > </cfquery> > > > > <cfdump var="#testquery#"> > > > > <cfscript> > > for(i=1;i lte 10;i=i+1) { > > querysetcell(myquery, "col1", 1, i); > > } > > </cfscript> > > > > <cfquery name="testquery" dbtype="query" > > cachedwithin="#createtimespan(0,1,0,0)#"> > > SELECT col1 AS column1 FROM myquery WHERE col1 <= 5 > > </cfquery> > > > > <cfdump var="#testquery#"> > > > > > -----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] > > > -- > ** 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] > > > -- > ** 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]
