Can cachedwithin use a variable?

BreakawayPaul wrote: I'm trying to cache a query on our live web server, but not on our testing server (developers need to see changes realtime, but the public doesn't). I tried something like this: <cfif listfirst(servername,".") eq "test"><cfset cachetime = 5><cfelse><cfset cachetime = 0></cfif> <cfquery name="GetContactInfo" datasource="MyDSN" cachedwithin=#createtimespan(0,0,cache,0)#"> SELECT.... But the results were unexpected (it didn't seem to work). Is there a way to do this?

This code is good, except for typing errors! Simply supply the missing quotes and change cache to cachetime.

<cfif listfirst(servername,".") eq "test"><cfset cachetime = 5><cfelse><cfset cachetime = 0></cfif>

<cfquery name="GetContactInfo" datasource="MyDSN" cachedwithin="#createtimespan(0,0,cachetime,0)#">

SELECT....

I might have to undo all this, as the pages are now loading super slow.  It's a big query, and there are a lot of pages, and since the query is different for each page, I didn't see any sense in caching each individual iteration.  So I took out the "where" statements and cached the entire table, then did a QoQ to grab the page info.

I guess maybe the entire table (well, more than one since I have a few joined) was too much.  It's the only reason I can think of for the pages loading slowly.

Your coding does is the opposite of your stated intent.