I've done some digging on this and everything I'm finding is ancient
(circa 2007).
Today I started getting a corrupt table error with every query that
has a cachedwithin set on it on one of my servers.
On another server, a backup for the main server, with (as best I can
tell) the same CF
Are you using any *s in your select statement?
On Mon, Apr 25, 2011 at 2:05 PM, Scott Weikert li...@alphageek.cc wrote:
I've done some digging on this and everything I'm finding is ancient
(circa 2007).
Today I started getting a corrupt table error with every query that
has a cachedwithin
Yes, and I had that in my one-off test - just removed the * and
specified a field, but no change, the cache-set query still bombs.
Again, this is code that has worked fine for years.
More on the timeline though - my server guy was doing a bit of tinkering
this morning (while I was doing some
I should also add that this is happening across multiple datasources on
the affected server, not just the one that my server admin guy fiddled with.
On 4/25/11 12:17 PM, Scott Weikert wrote:
Yes, and I had that in my one-off test - just removed the * and
specified a field, but no change, the
Well, finally got my server guy to cycle the CF service on the affected
box - and now queries with cachedwithin set seem to work fine.
I suspect somehow his fiddling with a DSN setting (which one, I'm
unsure) somehow tripped this ancient bug, and a service cycle cleared
that particular deck
Does anyone know how to cache a query using cfquery but in cfscript?
This works, query is cached for a day:
cfquery name=otherQry datasource=stuff cachedwithin=1
SELECT GETDATE()
/cfquery
cfdump var=#otherQry#
But this doesn't, it's always cached = false:
cfscript
Performance is pretty snappy using CachedWithin... with debug turned on, I'm
getting
total execution time of 172 ms, which is 156 ms for browse-properties.cfm,
110ms for the pagination CFC to execute, and 16 ms for
startup, parsing, compiling, loading, shutdown. 20 properties are
being
I really appreciate your advice for the CachedWithin. That's been a
big help!
Thanks, Mary Jo!
My pleasure, glad you got it worked out and are happy with the results.
--- MJS
~|
Adobe® ColdFusion® 8 software 8
I really appreciate your advice for the CachedWithin. That's been a
big help!
BTW - I did notice there are indeed some really huge chunks of whitespace in
your output which is certainly going to slow down how quickly the browser will
DL and render the page. There was a recent discussion
Thanks! I'll check out the discussion...
Rick
-Original Message-
From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 27, 2008 12:25 PM
To: CF-Talk
Subject: Re: CachedWithin question...
I really appreciate your advice for the CachedWithin. That's been a
big
Hi, all...
I've just begun using cachedwithin and ran into an issue
when running an insert query (not the one with the cachedwithin setting).
I got a duplicate key error. I traced that down to the fact that I had
used cachedwithin on another query (a select query) with a different name
I've just begun using cachedwithin and ran into an issue
when running an insert query (not the one with the
cachedwithin setting).
I got a duplicate key error. I traced that down to the fact
that I had used cachedwithin on another query (a select
query) with a different name
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 26, 2008 10:29 PM
To: CF-Talk
Subject: RE: CachedWithin question...
I've just begun using cachedwithin and ran into an issue
when running an insert query (not the one with the
cachedwithin setting
The measure of any performance enhancement is how it works under normal
load. When you look at this, if you're the only one running the application,
you're unlikely to see a significant performance difference. That said, I
usually see more of a difference than that when casually observing the
Hi all,
Given that you can't use cfqp and cachedwithin at the same time (serious
bummer), are there best practices for when you want to do both? All of the
solutions I can think of (application/server caching, some sort of custom
cachedwithin thing, etc) just seem annoying.
Also
It's resolved in CF8.
cheers,
barneyb
On Dec 19, 2007 12:39 PM, Ben Mueller [EMAIL PROTECTED] wrote:
Hi all,
Given that you can't use cfqp and cachedwithin at the same time (serious
bummer), are there best practices for when you want to do both? All of the
solutions I can think
On Dec 19, 2007 12:39 PM, Ben Mueller [EMAIL PROTECTED] wrote:
Hi all,
Given that you can't use cfqp and cachedwithin at the same time (serious
bummer), are there best practices for when you want to do both? All of the
solutions I can think of (application/server caching, some sort
for cfqueryparam/cachedwithin problem?
Hi all,
Given that you can't use cfqp and cachedwithin at the same time (serious
bummer), are there best practices for when you want to do both? All of
the solutions I can think of (application/server caching, some sort of
custom cachedwithin thing, etc
This has been resolved in CF8 (supposedly).
-Original Message-
From: Ben Mueller [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 2:40 PM
To: CF-Talk
Subject: Solutions for cfqueryparam/cachedwithin problem?
Hi all,
Given that you can't use cfqp and cachedwithin
Given that you can't use cfqp and cachedwithin at the same
time (serious bummer), are there best practices for when you
want to do both? All of the solutions I can think of
(application/server caching, some sort of custom cachedwithin
thing, etc) just seem annoying.
Also, is there any
This has been fixed in CF 8.
Awesome. Thanks, all.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
This has been fixed in CF 8.
Awesome. Thanks, all.
EXCEPT, if you're using mySQL, there's a bug that'll creep up from time to time
- Corrupt table. You'll need a hotfix.
I haven't seen this particular hotfix in the official releases, but adobe sent
it to me. Worked nicely. Just email me
On 12/19/07, Ben Mueller [EMAIL PROTECTED] wrote:
Hi all,
Given that you can't use cfqp and cachedwithin at the same time (serious
bummer), are there best practices for when you want to do both? All of the
solutions I can think of (application/server caching, some sort of custom
to the cachedwithin tag?
Thanks for the tips.
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
If I have various queries using the same query name but
different sql can they all be cached at the same time, or
will the new one overwrite the last one because of the name?
For example, search queries.
My understanding is that all the queries will be cached if they're
different.
I'm
If I have various queries using the same query name but different sql can they
all be cached at the same time, or will the new one overwrite the last one
because of the name? For example, search queries.
I'm wondering how best to serve the category and search results. We have about
1500
Hi Ken,
This bug was very recently discovered and it has been fixed. We will release a
hotfix for this very soom.
Thanks,
Rupesh
Adobe ColdFusion Team.
~|
Enterprise web applications, build robust, secure
scalable apps today
Awesome - it's truly excellent to see Adobe people in these lists.
On 8/27/07, Rupesh Kumar [EMAIL PROTECTED] wrote:
Hi Ken,
This bug was very recently discovered and it has been fixed. We will release
a hotfix for this very soom.
Thanks,
Rupesh
Adobe ColdFusion Team.
--
mxAjax /
Ken -
I did experience this one day while working on a development box. It was
indeed a very odd thing that had no rhyme or reason. I bounced the service on
my local machine and it has been working fine ever since. We have not had this
issue on the production box, and I hope we never do :).
Here's a quick update.
It looks like the problem is related to CF8's new ability to cache
queries that use cfqueryparam.
I found a comment attached to an entry on the subject at Blog in Black:
- http://www.bloginblack.de/archives/000887.cfm
The comment was made by Rahul... which I assume
This has become a possible show-stopping problem for me. I have a
high-load application running on CF8 that relies on query caching to
achieve good performance. It's never been a problem with CF7, but now
on CF8 I'm seeing the same problem described above (and elsewhere).
The problem appears
I am getting very strange behaviors while using CachedWithin on CF8. All the
sudden, something that has been working without fail for months in CF7 is
giving odd errors. On CF8 I will get intermittent errors that say corrupt
table null. If I remove the cachedwithin attribute the query runs
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote:
the sudden, something that has been working without fail for months in CF7
is giving odd errors. On CF8 I will get intermittent errors that say
corrupt table null. If I remove the cachedwithin attribute the query runs
fine. For example, I
state data.
In CF7 you could not use cachedwithin and cfqueryparam together, thus.no
cfqueryparam - I am doing some checks for injection before the data is passed
to the query. With 8 will be adding the cfqueryparam in b/c they can be used
together.
On Wednesday 08 Aug 2007, [EMAIL
Have you managed to get the SQL statement that runs when it falls over? What
does it look like?
Adrian
-Original Message-
From: Jason Fill
Sent: 08 August 2007 15:26
To: CF-Talk
Subject: ColdFusion 8 CachedWithin Issue
I am getting very strange behaviors while using CachedWithin
I am trying to use the CachedWithin attribute of my cfquery but will not
allow me to do this because I am using cfqueryparam in my Where
clause.
What is the reason for this?
~|
Introducing the Fusion Authority Quarterly Update
Certified Advanced ColdFusion Developer
Need Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 12:28 PM
To: CF-Talk
Subject: Using CachedWithin
I am trying to use the CachedWithin attribute of my cfquery
Chad McCue wrote:
I am trying to use the CachedWithin attribute of my cfquery but will not
allow me to do this because I am using cfqueryparam in my Where
clause.
What is the reason for this?
History :)
I am sure that if enough people tell Adobe we want to use automatic caching
CachedWithin
Chad McCue wrote:
I am trying to use the CachedWithin attribute of my cfquery but will not
allow me to do this because I am using cfqueryparam in my Where
clause.
What is the reason for this?
History :)
I am sure that if enough people tell Adobe we want to use automatic
PROTECTED]
Sent: Friday, September 08, 2006 12:29 PM
To: CF-Talk
Subject: Re: Using CachedWithin
Chad McCue wrote:
I am trying to use the CachedWithin attribute of my cfquery but will
not allow me to do this because I am using cfqueryparam in my Where
clause.
What is the reason for this?
History
I was wondering whatever anyone has written a modern query caching framework
(CFC or set of) that works in a way similar to cachedwithin parameter of
cfquery tag but offers none of its many limitations (the main limitation
would still be RAM but with full control over it) ?
TK
to cachedwithin parameter of
cfquery tag but offers none of its many limitations (the main limitation
would still be RAM but with full control over it) ?
TK
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting
of cachedwithin functionality
I was wondering whatever anyone has written a modern query caching framework
(CFC or set of) that works in a way similar to cachedwithin parameter of
cfquery tag but offers none of its many limitations (the main limitation
would still be RAM but with full control over
, 2006 8:17 PM
To: CF-Talk
Subject: RE: Own implementation of cachedwithin functionality
There are a few around
Have a look at this one
http://www.pixl8.co.uk/index.cfm/pcms/site.products.CF_Hypercache/
There is also a cf_turbocache
Snake
-Original Message-
From: Tom Kitta [mailto:[EMAIL
:
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 1:31 PM
To: CF-Talk
Subject: Re: ways to cache a query other than 'cachedwithin'
Okay, Jim, using this and your last suggestion, I have made a test case
that I think points to the same issue that I
Just to clarify - I'm assuming you mean that you're storing the instance of
the CFC in the application scope - not that within the cfc you're storing
the query into the application scope. Generally speaking, you don't want to
touch persistent scopes from within a CFC.
On 10/4/05, Ray Champagne
Sorry, yes, this is true. Should have been a little more clear. Thanks!
Deanna Schneider wrote:
Just to clarify - I'm assuming you mean that you're storing the instance of
the CFC in the application scope - not that within the cfc you're storing
the query into the application scope.
and depth. this query gets rather big, since I've got over 1300
categories and subcategories, so I'd like to be able to cache it. i
know how to use cachedwithin as a cfquery attribute, but this won't work
here, since I am modifying that query. is there another way to cache a
query? here's the code
Make a persisted CFC and put the query in it at a variables scope variable.
As long as the CFC is persisted, the query is persisted. MUCH cleaner than
cachedwithin/cachedafter. I have an article on it waiting to go which I can
send you off list (it's pre-edit)
I've got a simple query
Ray,
You could store the query in the application scope.
Robert
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 10:27 AM
To: CF-Talk
Subject: ways to cache a query other than 'cachedwithin'
I've got a simple query that will grab all
as the CFC is persisted, the query is persisted. MUCH cleaner than
cachedwithin/cachedafter. I have an article on it waiting to go which I can
send you off list (it's pre-edit)
I've got a simple query that will grab all my navigational menu items.
pretty simple. Now, I've added Mike D's
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 11:27 AM
To: CF-Talk
Subject: ways to cache a query other than 'cachedwithin'
I've got a simple query that will grab all my navigational menu items.
pretty simple. Now, I've added
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 12:05 PM
To: CF-Talk
Subject: RE: ways to cache a query other than 'cachedwithin'
I think there might be some confusion here... you're cfif statement
isn't
doing what I think you think
to cache a query other than 'cachedwithin'
I think there might be some confusion here... you're cfif statement
isn't
doing what I think you think its doing. ;^)
When you cache a query using cachedwithin it caches the query results
keyed
to the SQL statement (and information about it like user
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 12:12 PM
To: CF-Talk
Subject: RE: ways to cache a query other than 'cachedwithin'
Now I'm not so sure about that... but I think I'm still right.
The queryname is definitely used
that make_tree.cfm is being called every time when I turn on
debugging. Weird? Normal behavior?
cfquery name=qry_get_topcats datasource=#Request.DS#
username=#Request.user# password=#Request.pass#
cachedwithin=#Request.Cache#
SELECT Category_ID, Name, Parent_ID, ParentIDs
FROM Categories
WHERE
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 1:31 PM
To: CF-Talk
Subject: Re: ways to cache a query other than 'cachedwithin'
Okay, Jim, using this and your last suggestion, I have made a test case
that I think points
return in the
2000+ range ).
I thought the cachedwithin only ran on queries that were identical, it seems to
be running the cached query everytime the search is processed and ignoring the
fact that the searches are different
should return in
the 2000+ range ).
I thought the cachedwithin only ran on queries that were
identical, it seems to be running the cached query
everytime the search is processed and ignoring the fact
that the searches are different.
That's the way it's designed... Check the debugging output
I believe that cachedwithin will cach the query by its name assignment
regardless of any SQL changes you might do to it. Or are you saying you have
the same query name on multiple pages that is cached on all pages but the
SQL is different between those? I have never tested to see if that would
a search for 'c++' which returns
100 records. Another user does an any any search and gets
back the same records. ( btw the any any should return in
the 2000+ range ).
I thought the cachedwithin only ran on queries that were
identical, it seems to be running the cached query
everytime
Thanks for the clarification Jochem, I thought it was a database issue!
variables is impossible. The only thing you need to make sure is
that you don't just use the query string and name as keys, but
the bind variables as well.
Sorry, I'm not sure what you mean here though (may be too
variables is impossible. The only thing you need to make sure is
that you don't just use the query string and name as keys, but the
bind variables as well.
Sorry, I'm not sure what you mean here though (may be too
early in the morning and I'm being dumb)
Yeah it was too early, I
Thanks to everyone on their help on this. I'll start looking at the
suggested work-arounds.
Saturday
On 13/1/05 7:03 pm, Dave Watts [EMAIL PROTECTED] wrote:
It's not really a bug. Using CFQUERYPARAM with CFQUERY
means that rather than a regular statement, CF is able to use
prepared
Hi guys,
I noticed that i had an error occuring while my cfquery with a cachedwithin
also included a cfqueryparam, is that normal?
Thanks,
Saturday
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket
Yep. You can't mix em. Since I'd recommend cfqueryparam, I'd look into
caching your query manually.
On Thu, 13 Jan 2005 11:48:09 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
Hi guys,
I noticed that i had an error occuring while my cfquery with a cachedwithin
also included a cfqueryparam
On Thu, 13 Jan 2005 11:48:09 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
Hi guys,
I noticed that i had an error occuring while my cfquery with a cachedwithin
also included a cfqueryparam, is that normal?
Yep. You can't use cfqueryparam if you are using
cachedwithin/cachedafter. Lame
recommend cfqueryparam, I'd look into
caching your query manually.
On Thu, 13 Jan 2005 11:48:09 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
Hi guys,
I noticed that i had an error occuring while my cfquery with a cachedwithin
also included a cfqueryparam, is that normal?
Thanks,
Saturday
Oh MM, sort it out!
Not got anything to do with MM AFAIK... It's more a database issue cos
it uses bind variables which denote that the value will prolly change
from query to query but still allows the database to build a compiled
execution plan.
When you try and do a cachedwithin query in cf
Stuart Kidd wrote:
I noticed that i had an error occuring while my cfquery with a cachedwithin
also included a cfqueryparam, is that normal?
It is documented.
http://www.macromedia.com/go/wish/
Jochem
~|
Now there’s
COLLIE David wrote:
Not got anything to do with MM AFAIK... It's more a database issue cos
it uses bind variables which denote that the value will prolly change
from query to query but still allows the database to build a compiled
execution plan.
There are no technical reasons why query
Stuart Kidd wrote:
Oh MM, sort it out!
Caching queries manually, how is that done?
You could store it in a struct in the APPLICATION scope, along with
information identifying it and when it times out.
It's not really a bug. Using CFQUERYPARAM with CFQUERY means that
rather than a regular
It's not really a bug. Using CFQUERYPARAM with CFQUERY
means that rather than a regular statement, CF is able to use
prepared statements, so the execution plan (depending on the
RDBMS you're working with) can be cached for extra execution speed.
To cache with both, it's have to store the
|From: Bert Dawson [mailto:[EMAIL PROTECTED]
|Whether or not the RDBMS caches it CF will still have to go to
|the dB server and get it. If you use cachedwithin (or
|cachedafter) then it stays in CF's memory, and no trips to the
|dB are required, so i'd say cache it.
|And don't forget you could put
Personally I never use cachedwithin -- since you can't use cfqueryparam
with that. Cache within the application scope!
If you do that make sure you create the cache based on the query input.
I've seen many cases where developers just cached the query based on the
cfquery name, but were to stupid
I have a web site that uses CFMX 6.1 and MS SQL for data handling.
This question is probably because I don't know as much about MS SQL as I should, so
bear with me.
Is it efficient to use cachedwithin on a query that only returns a row or two in the
recordset? Keep in mind that this query
Whether or not the RDBMS caches it CF will still have to go to the dB
server and get it. If you use cachedwithin (or cachedafter) then it
stays in CF's memory, and no trips to the dB are required, so i'd say
cache it.
And don't forget you could put it in a persistent scope (either
application
neq 1
cfquery name=q_op datasource=PK1
cachedwithin=#createTimeSpan(7,0,0,0)#
SELECT MOC.MOC_OHNUMBER, MOC.MOC_REF_NO
FROM PK1.MOC MOC,
WHERE MOC.MOC_OHNUMBER = '12345'
AND ((MOC.MOC_OHTYPE='J')
/cfquery
cfelse
cfquery name=q_op datasource=PK1
SELECT MOC.MOC_OHNUMBER, MOC.MOC_REF_NO
Set the timespan with the conditional, and then run a single query:
cfif reinit
cfset timespan = createTimeSpan(0, 0, 0, 0) /
cfelse
cfset timespan = createTimeSpan(7, 0, 0, 0) /
/cfif
cfquery name=q_op datasource=PK1 cachedwithin=#timespan#
SELECT MOC.MOC_OHNUMBER, MOC.MOC_REF_NO
FROM PK1.MOC
Wouldn't something like this work?
cfif IsDefined(url.init)
cfset cachetime = createtimespan(0,0,0,0)
cfelse
cfset cachetime = createtimespan(7,0,0,0)
/cfif
cfquery Cachedwithin=cachetime
/cfquery
--
Ian Skinner
Web Programmer
BloodSource
file:///C:\Documents%20and
with cachedwithin
Set the timespan with the conditional, and then run a single query:
cfif reinit
cfset timespan = createTimeSpan(0, 0, 0, 0) /
cfelse
cfset timespan = createTimeSpan(7, 0, 0, 0) /
/cfif
cfquery name=q_op datasource=PK1 cachedwithin=#timespan#
SELECT MOC.MOC_OHNUMBER, MOC.MOC_REF_NO
FROM
; if called by an update template,
will do a new one.
Works fine and updates any cached queries immediately after updating data.
Hope this gives some ideas. Probably could be modified for the cachedwithin
attribute.
E. Keith Dodd
Wings of Eagles Services
www.wingserv.com
- Original Message
Try this:
In your application.cfm
cfif IsDefined(URL.refreshQueryCache)
cfset request.cachetimespan = CreateTimeSpan(0,0,0,0)
cfelse
cfset request.cachetimespan = CreateTimeSpan(1,0,0,0)
/cfif
Then...
cfquery name=query datasource=dsn
cachedwithin=#request.cachetimespan
When you have used cachedwithin in CFQUERY, is it possible to
override that before the cachedtime is up? For example,
cfif not isdefined(application.recache)
cfquery name=query datasource=dsn
cachedwithin=#createtimespan(0,1,0,0)#
...BLAH...
/cfquery
cfelse
cfquery name
=dsn
cachedwithin=#request.cache_qStates#
select *
from states
/cfquery
-
If you ever need to refresh or reset the query, like after a database
insert, update, or delete, simply do this:
cfset request.cache_qStates = createTimeSpan(0,0,0,0)
cfinclude template
When you have used cachedwithin in CFQUERY, is it possible to override that before the
cachedtime is up? For example,
cfif not isdefined(application.recache)
cfquery name=query datasource=dsn cachedwithin=#createtimespan(0,1,0,0)#
...BLAH...
/cfquery
cfelse
cfquery name=query
I'm trying to cache a query that receives parameters via cfqueryparam. I'm
getting the message that this is not allowed. I have some questions:
1) Why in a million years this is not allowed? I'm sure there must be a good
reason for that
2) How can i cache my query and still protect the
that it has something to do with how
CF stores the string of SQL that is generated within a CFQUERY. When you use
CFQUERYPARAM, the values aren't placed within the SQL statement sent to the
database, but are instead sent separately. When you use
CACHEDWITHIN/CACHEDAFTER, CF will only reuse the cached query
What is the best time to use cachedwithin? Would it be good to use on
lets say a message board? I am using Dain Andersons colorcoded tag, and
it takes awhile to parse everything if their is alot of html in the
query output. I was thinking of maybe caching it if that is a good idea.
Doug
What is the best time to use cachedwithin? Would it be good to
use on lets say a message board? I am using Dain Andersons
colorcoded tag, and it takes awhile to parse everything if their
is alot of html in the query output. I was thinking of maybe
caching it if that is a good idea
Perhaps you should take a look at the cfcache tag, it caches generated html.
jon
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 26, 2001 5:39 PM
Subject: cachedwithin?
What is the best time to use cachedwithin? Would
If you've used cachedwithin on a cfquery and set it for, say, 10 minutes, is
there any way to reset that query before the ten minutes is up?
for example,
the threadlist in my forum has a very chunky query, so I use cached within.
After the first load, it uses cached data which lasts
Sure. Set cachedwithin to a variable in application.cfm, say 0,0,5,0
Then set it to 0,0,0,0 when you want to re-set the cache.
best, paul
At 08:11 PM 12/30/00 +1100, you wrote:
If you've used cachedwithin on a cfquery and set it for, say, 10 minutes, is
there any way to reset that query
The following works:
cfquerydatasource="#request.dsn.name#"
username="#request.dsn.user#" password="#request.dsn.pwd#"
name="variables.getObjectList"
cachedwithin="#createtimespan(0,2,
This works:
cfset cache = "CreateTimeSpan(0,2,0,0)"
cfquery name="#qryName#"
datasource="#DSN#"
cachedwithin="#Evaluate(cache)#"
Bob
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2
It will also work if you just evaluate the timespan first:
cfset cache = "#CreateTimeSpan(0,2,0,0)#"
cfquery name="test" datasource="#datasource#" cachedWithin="#cache#"
Rick
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
S
" datasource="#dsn#"
SELECT field1
FROM table
WHERE field2 = '#i#'
/cfquery
/cfloop
Sharon
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 12:58 PM
Subject: questio
rth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 12:58 PM
Subject: questions about "cachedwithin"
To paraphrase the CFWACK:
'The ColdFusion caching logic takes cfif, cfloop, and other dynamic
structures in queries into account, ensuring that
the
last query run.
Sharon
-Original Message-
From: JF [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 2:30 PM
Subject: Re: questions about "cachedwithin"
That's not the behavior I've seen - CF is smart enough to look at the
select criteria
99 matches
Mail list logo