:
-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.
I've got a simple query that will grab all my navigational menu items.
pretty simple. Now, I've added Mike D's cf_maketree script to modify
the query by adding another field, called maketreesortlevel, that stores
the tree level so that I can output the menu items in the correct order
and
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 that
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
Hey, thanks Mike, I'd love to see the unedited version. CFC's are new
to me, but I've been looking for an excuse to jump in with both feet!
You can send it to this address.
Ray
Michael Dinowitz wrote:
Make a persisted CFC and put the query in it at a variables scope variable.
As long as
-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
Parent=Parent_ID
/cfif
Jim Davis wrote:
-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
-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
13 matches
Mail list logo