>
> > If I cache a query with:
> >
> > cfquery name="recordset" result="thisResult"
> > datasource="#application.datasource#"
> > cachedafter="#CreateDateTime(Year(Now()), Month(Now()), Day(Now()), 5, 0,
> > 0)#" cacheID="mycacheID&qu
Month(Now()), Day(Now()), 5, 0,
> 0)#" cacheID="mycacheID"
>
> ...is there then a way to use "mycacheID" to programmatically get cached
> query result set without actually re-running that same cfquery?
>
> (I have a situation where I have a bunch of cached ver
uery name="recordset" result="thisResult"
> datasource="#application.datasource#"
> cachedafter="#CreateDateTime(Year(Now()), Month(Now()), Day(Now()), 5, 0,
> 0)#" cacheID="mycacheID"
>
> ...is there then a way to use "mycacheID
If I cache a query with:
cfquery name="recordset" result="thisResult"
datasource="#application.datasource#"
cachedafter="#CreateDateTime(Year(Now()), Month(Now()), Day(Now()), 5, 0,
0)#" cacheID="mycacheID"
...is there then a way to use "
se. Incorrect Select List,
>
> Nathan
>
>
>
> -Original Message-
> From: Matt Quackenbush [mailto:quackfu...@gmail.com]
> Sent: Wednesday, November 07, 2012 4:27 PM
> To: cf-talk
> Subject: Re: Case statement inside cached query
>
>
> What does "wouldn'
e. Incorrect Select List,
>
> Nathan
>
>
>
> -Original Message-
> From: Matt Quackenbush [mailto:quackfu...@gmail.com]
> Sent: Wednesday, November 07, 2012 4:27 PM
> To: cf-talk
> Subject: Re: Case statement inside cached query
>
>
> What does "wouldn't
t Select List,
>
> Nathan
>
>
>
> -Original Message-
> From: Matt Quackenbush [mailto:quackfu...@gmail.com]
> Sent: Wednesday, November 07, 2012 4:27 PM
> To: cf-talk
> Subject: Re: Case statement inside cached query
>
>
> What does "wouldn't w
PM
To: cf-talk
Subject: Re: Case statement inside cached query
What does "wouldn't work" mean? Get results you didn't expect? If yes, what
did you get and what did you expect? Get an exception? If yes, where's the
stack trace?
On Wed, Nov 7, 2012 at 5:22 PM, N
SQL case statement at all or is there a way to get
> around it? I am trying to put this inside a cached query such as : Sum(
> case when A = 'B' then C else 0 end) as D ( C is numeric field). It
> wouldn't w
All:
Do cached queries allow SQL case statement at all or is there a way to get
around it? I am trying to put this inside a cached query such as : Sum( case
when A = 'B' then C else 0 end) as D ( C is numeric field). It wouldn't work.
I am on CF 8 and Oracle 11g.
Thank
, December 19, 2011 5:08 PM
To: cf-talk
Subject: Re: Cached query with execution time?
The 672ms time likely has something to do with the 100,000+ records in the
query being loaded into a variable. Otherwise you are correct in that the
times for small cached queries should be close to 0.
I think that
on
On Mon, Dec 19, 2011 at 6:50 PM, Jacob wrote:
>
> It this right? I thought if your cached a query there would be no
> execution
> time for the cached query. If I do not cache it, it takes about 4 seconds
> to run. I am trying to speed up a section of our site. This is a master
&
conds it likely means that the
database is doing a complete table scan because it doesn't have a good
index to use.
-Mike Chabot
On Mon, Dec 19, 2011 at 6:50 PM, Jacob wrote:
>
> It this right? I thought if your cached a query there would be no execution
> time for the cached query.
It this right? I thought if your cached a query there would be no execution
time for the cached query. If I do not cache it, it takes about 4 seconds
to run. I am trying to speed up a section of our site. This is a master
query and I use query of a query to reference it.
Master query
DVDList
lk
Subject: Re: Accessing a cached query in one function from another...
> If QoQ doesn't provide a performance improvement
> over database access, then I'm back to where I started.
It can, in some situations. It can also provide a decrease in
performance, in other situations.
> If QoQ doesn't provide a performance improvement
> over database access, then I'm back to where I started.
It can, in some situations. It can also provide a decrease in
performance, in other situations. You might need to do some testing to
see how well it works for you.
Query of query uses an
ubject: Re: Accessing a cached query in one function from another...
> So, to be able to run a "master query" that would
> essentially be an in-memory stand-in for the data
> on the database, and be able to run *various* types
> of queries on that data, rather than the exact same
ns not involving my
particular pagination scheme, but now I'm taking a
performance hit that I was trying to reduce.
-Original Message-
From: Justin Scott [mailto:jscott-li...@gravityfree.com]
Sent: Thursday, January 06, 2011 1:15 PM
To: cf-talk
Subject: RE: Accessing a cached query in one f
> So, to be able to run a "master query" that would
> essentially be an in-memory stand-in for the data
> on the database, and be able to run *various* types
> of queries on that data, rather than the exact same
> query, I would need to put the "master query" into
> a persistent scope. Right?
Ye
> I guess at this point, I'm uncertain of the difference
> between utilizing a "cachedWithin" query as opposed to
> a "query-of-query"...
The cachedWithin attribute will cause the CF engine to store the query
results in memory for the specified amount of time, even across page loads.
When you run
achedWithin" query as opposed to
a "query-of-query"...
Rick
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Thursday, January 06, 2011 12:40 PM
To: cf-talk
Subject: Re: Accessing a cached query in one function from another...
> I haven't made
> I haven't made use of a persistent scope to this point.
> I thought, perhaps, that just using:
>
> "#createTimeSpan(0,1,0,0)#">
>
> in the opening tag made the query data persistent without
> utilizing a persistent scope. As I mentioned to Justin, just
> my ignorance about how caching works.
-talk
Subject: Re: Accessing a cached query in one function from another...
> I'm trying to gain some extra speed on some complex queries
> and am venturing into my first cached-query experience.
>
> What I'm trying to do is run an initial cfc function that
> caches all n
: cf-talk
Subject: RE: Accessing a cached query in one function from another...
> I'm trying to gain some extra speed on some complex
> queries and am venturing into my first cached-query
> experience.
Wouldn't a "cachedWithin" attribute on the query in question be
> I'm trying to gain some extra speed on some complex queries
> and am venturing into my first cached-query experience.
>
> What I'm trying to do is run an initial cfc function that
> caches all needed data for subsequent queries.
>
> After the cached query is crea
> I'm trying to gain some extra speed on some complex
> queries and am venturing into my first cached-query
> experience.
Wouldn't a "cachedWithin" attribute on the query in question be sufficient
to speed things up?
Notwithstanding that, when you cache a query in
Hi, all...
I'm trying to gain some extra speed on some complex queries
and am venturing into my first cached-query experience.
What I'm trying to do is run an initial cfc function that
caches all needed data for subsequent queries.
After the cached query is created, I want to access
. Would that actually get rid of the cached query?
>>
>
> That won't work, but you can flush a single query from the cache by
> rerunning the query with only one change - set CACHEDWITHIN to
> CreateTimeSpan(0, 0, 0, 0). Everything else about the query must
> match, inclu
> What if at the end of the process I ran the query using the same query name
> and no caching. Would that actually get rid of the cached query?
That won't work, but you can flush a single query from the cache by
rerunning the query with only one change - set CACHEDWITHIN to
CreateTi
before it uses the cached query.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your l
uation?
Adrian
> -Original Message-
> From: Robert Harrison [mailto:rob...@austin-williams.com]
> Sent: 11 February 2009 16:23
> To: cf-talk
> Subject: RE: Query Caching Function: Clearing Cached Query
>
>
> I looked in the docs first.
>
> What if at the end of the
I looked in the docs first.
What if at the end of the process I ran the query using the same query name
and no caching. Would that actually get rid of the cached query?
Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 117
16:07
> To: cf-talk
> Subject: Query Caching Function: Clearing Cached Query
>
>
> I have a huge query that is used in a timed loop process completes. The
> process could take from a minute to 15 hours, and it runs the query
> each
> time is goes through a loop.
>
> If I
I have a huge query that is used in a timed loop process completes. The
process could take from a minute to 15 hours, and it runs the query each
time is goes through a loop.
If I cache the query (cached within the last 15 hours), it can save a lot of
re-querying processing... but what if the pro
Options are always appreciated!
Thanks again.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 11, 2005 10:03 AM
To: CF-Talk
Subject: RE: Cached query - Any way to tell when it was cached?
I don't blame you. :) I'm just a big fan of opt
D]
> Sent: Tuesday, May 10, 2005 7:19 PM
> To: CF-Talk
> Subject: RE: Cached query - Any way to tell when it was
> cached?
>> I think Ian's may be the way to go. I am using
>> cachedwithin as the data
>> changes frequently so we cache it for 6 hours. I don't
&
.
Iirc even before that you could reference cfquery.executionTime --
I've never seen an executed query return zero, and I've never seen a
cached query return anything other than zero, so it seems like it's a
reasonable indicator. Admittedly it's not very precise / explicite...
s. isaac de
ED]> wrote:
> Yeah, for simplicities sake I'll go with the other one, heh.
>
> Thanks for the help guys.
>
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 10, 2005 7:19 PM
> To: CF-Talk
> Subject: RE: Cached query - An
Yeah, for simplicities sake I'll go with the other one, heh.
Thanks for the help guys.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 7:19 PM
To: CF-Talk
Subject: RE: Cached query - Any way to tell when it was cached?
> I think I
> I think Ian's may be the way to go. I am using
> cachedwithin as the data
> changes frequently so we cache it for 6 hours. I don't
> think cachedafter
> will work.
sure it will -- although the alternative is simpler...
but fyi here's the way to accomplish 6 hr caching with cachedafter:
ubject: Re: Cached query - Any way to tell when it was cached?
> Is there a way, possibly as easy as an undocumented query
> variable
> (query_name.CachedSince - one can dream no?), to return
> the timestamp of
> when a query was last cached? Was looking for an easy way
> to have a &
> How about adding:
> getdate() AS cachedSince
> to the list of columns in the query. getdate() is a SQL
> Server function but most dbs should have an equivalent
> function.
good point...
sql server getdate()
access now()
oracle current_date()
s. isaac dealey 954.522.6080
new epoch : isn't
> Is there a way, possibly as easy as an undocumented query
> variable
> (query_name.CachedSince - one can dream no?), to return
> the timestamp of
> when a query was last cached? Was looking for an easy way
> to have a "This
> report last generated on: X" display an a page with a
> large recordse
How about adding:
getdate() AS cachedSince
to the list of columns in the query. getdate() is a SQL Server function but
most dbs should have an equivalent function.
Ian
~|
Discover CFTicket - The leading ColdFusion Help Desk an
Is there a way, possibly as easy as an undocumented query variable
(query_name.CachedSince - one can dream no?), to return the timestamp of
when a query was last cached? Was looking for an easy way to have a "This
report last generated on: X" display an a page with a large recordset that
we curren
, KS 66211
(913) 754-4272
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 2:42 PM
To: CF-Talk
Subject: Re: Cached Query and CFQUERYPARAM
Whoops. Brain fart. I had removed the cfqueryparam from the WHERE
clause... Makes sense now.
- O
Whoops. Brain fart. I had removed the cfqueryparam from the WHERE
clause... Makes sense now.
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 19, 2004 1:36 PM
Subject: Cached Query an
:
SELECT something, somethingsomething
FROM mytable
WHERE mytableid =
And if I call that query alternately with different identifiers, 1, 2, 3,
etc., will the query remain cached? In CF's debugging output I'm seeing
'Time=Cached Query', but I don't understand how CF could cache
> From: Jim McAtee
>
> Cached queries are named and tracked by CF on a server-wide
> basis, correct? Say I cache a query with the name "myquery",
> will an unrelated query (different SQL statement) with the
> same queryname cause the first query to be flushed, or will
> it have no effect on t
Cached queries are named and tracked by CF on a server-wide basis,
correct? Say I cache a query with the name "myquery", will an unrelated
query (different SQL statement) with the same queryname cause the first
query to be flushed, or will it have no effect on the caching?
[Todays Threads]
[Thi
o, CA
-Original Message-
From: Nikhil Madani [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 1:18 PM
To: CF-Talk
Subject: Cached Query Help
CFMX 6.1 Cached Query Problem:
I have an XML file that I'm reading into a query object (to facilitate faster search) using the QueryNew(), QueryAd
CFMX 6.1 Cached Query Problem:
I have an XML file that I'm reading into a query object (to facilitate faster search) using the QueryNew(), QueryAddRow() and QuerySetCell() functions. Now, I need to hit this query often and I decided that caching it would be a good idea. Hence I did a que
spikes up to
> about 400 MB when the app. is running.
> My question then is- Is there a way to find out exactly how much each
> cached query and other objects (I have components being loaded) are
> using up in the memory?
Hi Nikhil,
There is no easy way to determine the size of an o
running.
My question then is- Is there a way to find out exactly how much each cached query and other objects (I have components being loaded) are using up in the memory?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Thanks for your replies, it's good to know I'm not alone at
least...I'm kind of tempted to call Macromedia Support, as there is no
mention of the error anywhere on the Macr site, or even on Google.
I'm a bit scared I will end up explaining the same thing 10 times
before I get to someone who tells m
On Monday 27 Jan 2003 21:17 pm, jon hall wrote:
> Anyone seen this error, or know what could be causing it?
We see in on CF5 too, at random times and pages.
--
Tom C
'Morals are private. Decency is public.'
- Rita Mae Brown
- 'Starting from Scratch: A Different Kind of Writer's Manual'
~~~
I've seen it, too. On CF5. Not as often as you are.
best, paul
At 04:17 PM 1/27/03 -0500, you wrote:
> On CF5, I'm getting this error on random pages at random times. The
> queries have nothing in common other than they connect to the same
> datasource.
> However I am starting to get i
On CF5, I'm getting this error on random pages at random times. The
queries have nothing in common other than they connect to the same
datasource.
However I am starting to get it fairly (1-2 times a day, and
today 3 times) consistently now as load starts to climb on a new app.
Anyone s
d out the speed benefits of CFQUERYPARAM
ps> (which cannot be used on cached queries).
A cached query will blow away any query speedwise that connects to the
database, cfqueryparam or not.
--
jon
~|
Archives: http://www.house
ave received this e-mail in error please delete it immediately and
>advise us by return e-mail to [EMAIL PROTECTED]
>
>*
>
>
>-Original Message-
>From: paul smith [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 16, 2003 4:57 PM
>To: CF-Talk
>Subject: Re: Defi
Yes :)
cfquery looks at the actual sql string (and the cfquery parameters) to
decide whether or not to look at the cache, or make a connection to
the database, not just the name.
--
jon
mailto:[EMAIL PROTECTED]
Thursday, January 16, 2003, 5:27:15 PM, you wrote:
JM> So if I understand that corr
]
*
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 4:57 PM
To: CF-Talk
Subject: Re: Definition of a cached query
At 04:18 PM 1/16/03 -0500, you wrote:
>Could someone point me to what exactly is a cached query.
It's kind of what it says. Th
At 04:18 PM 1/16/03 -0500, you wrote:
>Could someone point me to what exactly is a cached query.
It's kind of what it says. The record set is stored in memory for the
specified time. As long as it hasn't expired, subsequent requests are
pulled from memory. On SMARTERyellow
Could someone point me to what exactly is a cached query. Like once a use
cachedwithin is it pulling the exact data that it did before, or is it going
back to the datasource a little faster? What about if I am passing
parameters to it, does it have to cache each instance of that query?
Robert
> make of this error message?
> >
> > Retrieval of cached query failed
>
>You might find this useful:
>http://www.macromedia.com/v1/handlers/index.cfm?ID=23008&Method=Full&PageCal
>l=/support/index.cfm
>
>On the other hand, I've encountered this a coup
> It's funny you should bring caching up, Dave. What do you
> make of this error message?
>
> Retrieval of cached query failed
You might find this useful:
http://www.macromedia.com/v1/handlers/index.cfm?ID=23008&Method=Full&PageCal
l=/support/index.cfm
On the other ha
Is it possible ur surpassing the max cache query setting? Not sure...try
jacking it up.
Stace
-Original Message-
From: Fregas [mailto:lists@;mediaartisans.com]
Sent: Tuesday, October 29, 2002 5:27 PM
To: CF-Talk
Subject: Retrieval of cached query failed
We have a high traffic site that
We have a high traffic site that is plagued by the following error:
CFQuery Retrieval of cached query failedThe error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position (39:1) to
(39:133).The error occurred while processing an element with a
day, September 25, 2002 6:54 AM
CG> To: CF-Talk
CG> Subject: Retrieval of cached query failed
CG> oi CF-Talk,!!
CG> I keep gettin the above error on one of my servers all of a sudden,
CG> and also CFServer is pegging
CG> the cpu at 100% for no apparent reason, and will not
o: CF-Talk
Subject: Retrieval of cached query failed
oi CF-Talk,!!
I keep gettin the above error on one of my servers all of a sudden,
and also CFServer is pegging
the cpu at 100% for no apparent reason, and will not settle until
restarting the service. Anyone
seen anything like this?
oi CF-Talk,!!
I keep gettin the above error on one of my servers all of a sudden, and also
CFServer is pegging
the cpu at 100% for no apparent reason, and will not settle until restarting the
service. Anyone
seen anything like this??? Or know what causes it?
--
Critz
Macrome
Brook Davies wrote:
> Is it possible to update a row in a cached query? I want to do this when a
> record in the cached record set is edited, as opposed to reloading/caching
> the entire query.
>
> I tried:
>
> attributes.start)>
In CF 4.5 this used to work (at least
update a row in a cached query? I want to do this when a
BD> record in the cached record set is edited, as opposed to reloading/caching
BD> the entire query.
BD> I tried:
BD> >
BD> Which generated a java error. And I also tried:
BD> Variables[attributes.query_name
possible to update a row in a cached query?
>
>No, not if you mean queries cached using CACHEDWITHIN/CACHEDAFTER in the
>CFQUERY tag.
>
> > I tried:
> >
> > > "TestValue", attributes.start)>
> >
> > Which generated a java error. And I also
> Is it possible to update a row in a cached query?
No, not if you mean queries cached using CACHEDWITHIN/CACHEDAFTER in the
CFQUERY tag.
> I tried:
>
> "TestValue", attributes.start)>
>
> Which generated a java error. And I also tried:
>
> Vari
Is it possible to update a row in a cached query? I want to do this when a
record in the cached record set is edited, as opposed to reloading/caching
the entire query.
I tried:
Which generated a java error. And I also tried:
Which did not generate an error but did not update the cached
Quoting Bryan Love <[EMAIL PROTECTED]>:
> I've found in the past that is one of the (if not the only...) good
> arguments for the use of application variables.
Looks like a good use of a request variable to me. Datasource names also make
good request variables. I don't like having to lock thin
EMAIL PROTECTED]
+---+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-Original Message-
From: mr_urc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 1:27 PM
To: CF-Talk
Quoting "Burcham, Steve" <[EMAIL PROTECTED]>:
> What is the best way to 'kill' a cached query on a logout sequence?
The only way that I know of to kill a cached query is to run the query with
cachedwith set to one second. If there's a better way, I'
What is the best way to 'kill' a cached query on a logout sequence?
Thank you.
Steve Burcham
Webmaster - Field Support Team
RDO Equipment Co.
Phone (701) 239-8755
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
_
date.cfm)
>
>> > datasource="testingDB">
>>select * from Welcome
>>
>
>The select expires the cache and then when the next person
hits the home
>page it will be recached for two days
>
>John.
>
>> -Original Messa
Updating the welcome query will not work because it does not return a result
set.
-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:28 PM
To: CF-Talk
Subject: [Re:] RE: cached query
In the home page home.index, i have a query like this
: ] RE: cached query
No after your
>
> update Welcome
> set message = '#form.welcomemsg#',
> dateedited = #CreateODBCDateTime(Now())#
>
Do (all in your welcomeupdate.cfm)
> datasource="testingDB">
>select * from Welcome
>
fresh=true" they can see the update
to the page - and they will know that will be there for everyone inside of
10 minutes.
-Mark
-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 3:34 PM
To: CF-Talk
Subject: cached query
hi all,
i have buil
t;
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 4:33 PM
Subject: cached query
> hi all,
> i have built a website for a client where the home page is totally
> dynamics ( the cfm file has almost 10 queries accessing 10 different
> tables in order t
expires the cache and then when the next person hits the home
page it will be recached for two days
John.
> -Original Message-
> From: FARRAH NG [mailto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 22:28
> To: CF-Talk
> Subject: [Re:] RE: cached query
>
>
>
w())#
so what i should do is to put cachedwithin="#createtimespan(0,0,0,0)#"
in the UpdateMessage query in the welcomeupdate.cfm and each time
the query update the database the cached query "getWelcome" in the
home.index will be updated instantly, is that correct ?
thanks a l
ilto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 21:34
> To: CF-Talk
> Subject: cached query
>
>
> hi all,
> i have built a website for a client where the home page is
> totally dynamics ( the cfm file has almost 10 queries
> accessing 10 different tables in order to popul
days, the home page will not
be able to display the lastest info. Is there a way to refresh all
the cached query once the client update the database, so all the
cached queries will also be updated instantly without waiting for the
CACHEDWITHIN to expire.
Anyone has any idea is very welcom
can you post the code that you're using?
Thanks
-Original Message-
From: Fregas [mailto:[EMAIL PROTECTED]]
Sent: Monday, 26 November 2001 5:24 p.m.
To: CF-Talk
Subject: cached query
CFQuery
Retrieval of cached query failed
I was under the impression that if a cached query w
CFQuery
Retrieval of cached query failed
I was under the impression that if a cached query wasn't already loaded,
it would go ahead ond run it from the DB. Is this wrong? I am using
CF4.5
~~
Get the mailserver that powers this list at
I have seen this error occur when the following sequence occurs:
1. The query to be cached is run for the first time in
preparation for putting the results in memory.
2. Another request for the cached query comes in before the
first query are actually placed in memory. (Even if it is only a
Hi all
The saga of our bizarre server errors continues anyone seen (and
more importantly, FIXED!) this one before?
"Retrieval of cached query failed"
I've scoured the Allaire forums, and the only answers I found were -
"This error typically happens in one of thr
e time span to cache within, and you're set :).
hope this helps!
Norman
-Original Message-
From: Paul Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 4:15 PM
To: CF-Talk
Subject: Re: Cached Query
If it's cached you don't need to put it in Application scope
If it's cached you don't need to put it in Application scope
(and probably don't want to).
I put mine in Request scope, but I'm not sure I need to.
best, paul
At 02:52 PM 6/14/01 -0400, you wrote:
>Is a cached query always within the application scope? Or do I ne
Is a cached query always within the application scope? Or do I need to add
"Application." before the query name?
Thanks
Duncan Hays
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionaut
01 1:00 PM
To: CF-Talk
Subject: Cached Query! Was Working Yesterday!
CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (39:1) to (40:43).
This is the entire message. Why would it do thi
If your developement server is different than your production server, make
sure that cached queries is enable in CF Adminstrator...
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:00 PM
To: CF-Talk
Subject: Cached Query! Was Working
CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (39:1) to (40:43).
This is the entire message. Why would it do this? It was working yesterday, I went
live with it, now it's fa
Has anyone ever seen the error:
CFQuery Retrieval of cached query failed
I just added query caching to a page from an old web site, and it works for
awhile, but then it starts generating this message. We have been having
some major problems with out SQL Server 2000 database, so I was looking
1 - 100 of 115 matches
Mail list logo
