On Wednesday 24 January 2007 19:01, DURETTE, STEVEN J (ASI-AIT) wrote:
This code isn't mine. I'm just trying to trouble shoot the excessive
amounts of memory that are being used and not released. The site has a
low hit count, so I don't see why it should be using soo much.
Fusion Reactor !
Is there a scope that holds cached queries and if so how can it be
access to see what is in there?
This is related to my previous post about enumerating what is in an
instance's memory block.
Thanks,
Steve
~|
Upgrade
Is there a scope that holds cached queries and if so how can
it be access to see what is in there?
No, there isn't. If you want to manage memory directly, store your queries
in Session, Application or Server scope.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software
, January 24, 2007 12:48 PM
To: CF-Talk
Subject: RE: What scope are cached queries in?
Is there a scope that holds cached queries and if so how can
it be access to see what is in there?
No, there isn't. If you want to manage memory directly, store your
queries
in Session, Application or Server
On Tuesday 26 September 2006 19:30, Snake wrote:
You don't want to store in sesison scope, otherwise a copy of the query
will be stored for each and every visitor, which could result in jrun using
up all the available memory.
It *could*, but you'd need a lot of visitors on a very under spec'ed
I did think of storing them in a session/application scope but to be honest
I am currently thinking I can safely ignore text fields as any single quotes
would be excaped anyway, I can then do...
cfif isNumeric(somefield)do the sqlcfelsecfthrow type=an
error/cfif
And that would prevent any
On Wednesday 27 September 2006 14:32, James Smith wrote:
And that would prevent any injection attempts. I could then cache the
queries the regular way, no?
It will execute slower than a query that uses cfqueryparam though.
--
Tom Chiverton
Helping to vitalistically bully end-to-end bandwidth
On 9/26/06, Che Vilnonis [EMAIL PROTECTED] wrote:
Wait for Scorpio (CF8). This was just answered on the list a few weeks ago.
Try one of these links:
Not exactly 100%
And no, that is not a promise or a public commitment (yet). ;-) --- Ben
~~~
Casey
I have a need to cache some queries. For safety and security these queries
use cfqueryparam.
You are not allowed to use cachedWithin or cachedAfter with queries that
contain a cfqueryparam.
Any idea how I go about caching these?
--
Jay
%3Ahttp%3A%2F%2Fwww.houseoffusion.c
om%3BFORID%3A1%3Bhl=en
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 1:08 PM
To: CF-Talk
Subject: Cached queries
I have a need to cache some queries. For safety and security these queries
use cfqueryparam
You can make a function that caches the query object in the application scope.
Have the function return type be query, and when the query is called, check
the cache time and re-run the query if the cache has expired.
~|
: Cached queries
I have a need to cache some queries. For safety and security these queries
use cfqueryparam.
You are not allowed to use cachedWithin or cachedAfter with queries that
contain a cfqueryparam.
Any idea how I go about caching these?
--
Jay
-Talk
Subject: RE: Cached queries
Or, you could store your queries within persistent memory variables
(Session, Application, Server).
This might be a better link to help: http://tinyurl.com/kou23
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 1
I know you can zero out the cachedwithin times, but that
doesn't seem feasible as the caches are in all sorts of CFCs and have
various timeouts assigned.
It's worth noting that the caching is keyed on the text of the query. And once
you execute it once with a timeout low enough that it hits
Thank you, Raymond. (I just posted my self-followup coming to the same
conclusion before your response came in.)
Clearing all of the queries is exactly what I wanted to do, so problem solved.
cfobjectcache action=refresh will clear ALL of them.
To clear one query, rerun the query with the
Self-followup:
I researched a bit and came up with cfobjectcache action=clear/. It seems
to do the trick, although I've just read elsewhere that it may not clear all
queries. However, some is better than none for my purposes and it worked in my
test just now.
Anyone used it before? I had
I fear I already know the answer to this, but is it possible?
We use cachedwithin queries all over the place and want to be able to flush
CF's memory when needed to reflect changes from the database immediately. Is
there any way to do this other than restarting the CF service? I know you can
Just went through this yesterday. Basically you can add a space or
change the query so CF thinks it's a new query and it won't use the
cached version. However, that only works for a single query.
Otherwise, you have to restart the server.
Jeff Guillaume wrote:
I fear I already know the
cfobjectcache action=refresh will clear ALL of them.
To clear one query, rerun the query with the EXACT same settings (sql,
attributes, etc) but with a timeout of zero. When I say exact same -
it must be the exact same even when it comes to white space.
On 9/7/06, Jeff Guillaume [EMAIL
precisely how the access times for a
query scales as the number of cached queries increase (a hash?), and how those
access times compare to self-caching in arrays or structs.
Regards,
Terry
~|
Logware (www.logware.us): a new
each one is using at any point in time.
Additionally, it would be nice to know precisely how the access times for a
query scales as the number of cached queries increase (a hash?), and how
those access times compare to self-caching in arrays or structs.
Regards,
Terry
Honestly, you really ought not to care.
The reason I care is that when you're using a large number of cached queries of
differing (sometimes variable) sizes in a large, highly loaded, dynamic
environment, it's not at all easy to know how many queries you ought to cache,
nor what sort
been
DEMONSTRATED insufficient.
cheers,
barneyb
On 12/7/05, Terry Ford [EMAIL PROTECTED] wrote:
Honestly, you really ought not to care.
The reason I care is that when you're using a large number of cached queries
of differing (sometimes variable) sizes in a large, highly loaded, dynamic
throw a dart at a board to
determine how much memory your CF cached queries are really using.
Terry
If you really care that much, you're going to be doing some pretty
in-depth load testing anyway, so you can vary the different cache
amounts (query cache, other manual caches) and get app-specific
Because of the way memory usage is related to JVM garbage collection
and other processes, I agree with Barney that load testing of your
whole app with your data is the best way to see if you have problems,
rather than trying to put together a picture based on measurements of
individual bits of the
Okay, this is probably something obvious I'm either overlooking or not
thinking of. For some reason, I can figure out the really complicated
things far easier than the ones that should be simple. Anyway
Is there a way to force CF 6.1 to update a cached query programatically.
That is,
set cachedwithin to 0?
Okay, this is probably something obvious I'm either overlooking or not
thinking of. For some reason, I can figure out the really complicated
things far easier than the ones that should be simple. Anyway
Is there a way to force CF 6.1 to update a cached query
Doom [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 10:43 AM
To: CF-Talk
Subject: Flushing Cached Queries
Okay, this is probably something obvious I'm either overlooking or not
thinking of. For some reason, I can figure out the really complicated
things far easier than the ones that should
Is there a way to force CF 6.1 to update a cached
query programatically.
There are a couple of potential options off the top of my head. If the
times that the query is run are set, you could use a cachedwithin attribute
to force it to expire after a certain period. If you want to force a
after the database update use a cfobjectcache?
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b11.htm
On 10/24/05, John Beynon [EMAIL PROTECTED] wrote:
set cachedwithin to 0?
Okay, this is probably something obvious I'm either overlooking or not
thinking of. For some reason, I
Hi there,
Is there away of telling if a query was generated from a cached query
without setting a variable or anything??
Cheers
Andy
www.andyjarrett.co.uk
~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
AM
Subject: cached Queries
Hi there,
Is there away of telling if a query was generated from a cached query
without setting a variable or anything??
Cheers
Andy
www.andyjarrett.co.uk
~|
Purchase from House of Fusion
Check out the new TechNote at:
http://www.macromedia.com/support/coldfusion/ts/documents/cached_queries_max
_zero.htm
http://www.macromedia.com/support/coldfusion/ts/documents/cached_queries_ma
x_zero.htm
Intro:
Cached queries within Macromedia ColdFusion MX are used to retrieve data
result
to manually
assemble the URL every time.
Cheers,
barneyb
-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 11:58 AM
To: CF-Talk
Subject: ColdFusion TechNote Notification: Behavior of
cached queries whe n maximum number is set to 0
Check
-Original Message-
From: Les Irvin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 2:29 PM
To: CF-Talk
Subject: Cached queries
I would like to carry query results across a number of pages
as users move
through the site without having to perform the query on each page.
I understand
From: Les Irvin
I would like to carry query results across a number of pages
as users move through the site without having to perform the
query on each page.
I understand persistant queries with the cachewithin
attribute but that's not possible with this query as it
includes an
I would like to carry query results across a number of pages as users move
through the site without having to perform the query on each page.
I understand persistant queries with the cachewithin attribute but that's
not possible with this query as it includes an embedded CFQUERYPARAM tag.
What's
On Tuesday 06 Apr 2004 19:09 pm, Dave Watts wrote:
How many users are you serving from your desktop?
A couple :-}
There are many reasons why queries may run slowly or quickly, of course.
I suppose all you can really do is benchmark the various methods in your own
app...
--
Tom Chiverton
There are many reasons why queries may run slowly or
quickly, of course.
I suppose all you can really do is benchmark the various
methods in your own app...
This, of course, is the secret to success with any web application.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
I have an app with a front end (the main site that users see) and a
backend (an admin app for updating articles, calendar events, etc).On
the front end, I want to use cached queries to make the performance
better.However, if I use cached queries and an admin user goes into
the backend and adds
You can use cfobjectcache action = "" to clear all cached queries
Qasim
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:53 AM
To: CF-Talk
Subject: Cached Queries
I have an app with a front end (the main site that
just curious how CF differentiates cached queries.
If the front end has one application name and the backend has another,
does it handle the cached queries separate even though they're the exact
same query?
John
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday
You can use cfobjectcache action = "" to clear all cached queries
I'm not sure that's what he's after. If you use the above, you blow away the
entire cache, instead of just the query or queries that you want to refresh.
You could store the query results in the Application scope (or s
just curious how CF differentiates cached queries.
If the front end has one application name and the backend has another,
does it handle the cached queries separate even though they're the exact
same query?
While setting a createTimeSpan value of 0 will indeed work, the results
won't take effect
queries to make the performance
better. However, if I use cached queries and an admin user goes into
the backend and adds a new article, then goes and views the front end,
he won't see the new update automatically, right? How could I (in my
admin code) flush the cache for that particular query or set
To: CF-Talk
Subject: RE: Cached Queries
Is there any way to clear just individual queries?Would the best
method for doing that be to execute the same query and give it a new
cachedwithin value of #CreateTimeSpan(0,0,0,0)# to kill the cache from
the backend and then when the frontend query is called
On Tuesday 06 Apr 2004 14:52 pm, Burns, John D wrote:
the backend and adds a new article, then goes and views the front end,
he won't see the new update automatically, right?How could I (in my
If you use cfqueryparam, you don't need to worry about caching your querys
yourself.
Oh, and it's
While setting a createTimeSpan value of 0 will indeed work,
the results won't take effect until the *next* page request,
I think. In the above scenario, you'd be relying on somebody
hitting that page again before showing the proper results
(even if you just hit Refresh in your browser,
If you use cfqueryparam, you don't need to worry about
caching your querys yourself. Oh, and it's more secure.
Oh, and quicker.
While I just love the CFQUERYPARAM tag to death, it's not a substitute for
in-memory recordset caching. It doesn't cache recordsets in memory, and
therefore isn't
looked at the CFDOCS and don't see any info
about it auto-caching when using cfqueryparam.Any insight would be
appreciated.
John
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:33 AM
To: CF-Talk
Subject: Re: Cached Queries
On Tuesday 06
the cache?
Yes, that works perfectly fine. In fact, if you want to avoid having the
frontend user wait for the database, you can flush the query as you
described above, then rerun it with the appropriate cache time again in your
backend page.
I'm just curious how CF differentiates cached queries
No, I'm pretty sure that once you run the query with CACHEDWITHIN set to a
timespan of zero, that'll remove the previous cached query from the cache.
Someone will need to rerun the query against the database to recache it,
though.
That was my point (however unclear it may have been!), if I'm
cfqueryparam makes it so your query is cached
automatically?
No, it doesn't.
I can see using cfqueryparam in the second instance, but I
don't see how it helps in the first and I don't see how using
it caches my queries or improves performance.I looked at
the CFDOCS and don't see any
No, I'm pretty sure that once you run the query with
CACHEDWITHIN set to a timespan of zero, that'll remove
the previous cached query from the cache. Someone will
need to rerun the query against the database to recache
it, though.
That was my point (however unclear it may have
On Tuesday 06 Apr 2004 16:00 pm, Dave Watts wrote:
When you use CFQUERYPARAM, the database will generally cache query
execution plans, which can speed up future database queries using the same
plan.
Hmm...
:tests
I'll typical get consistant ~3ms query times using cfqueryparam, compaired to
I'll typical get consistant ~3ms query times using
cfqueryparam, compaired to much longer without.
Of course, caching into a persistant scope will get
you a 0ms query time, but then you have to manage the
cache (I really must write a generic memoiser CFC)
yourself. And if you're
On Tuesday 06 Apr 2004 17:09 pm, Dave Watts wrote:
Unfortunately, even with consistent use of CFQUERYPARAM, many of us will
have longer query times than 3 milliseconds.
Really ?!?
This is on a very loaded desktop dev box, to a remote Oracle, that isn't on
the best hardware either...
--
Tom
Unfortunately, even with consistent use of CFQUERYPARAM, many
of us will have longer query times than 3 milliseconds.
Really ?!?
This is on a very loaded desktop dev box, to a remote Oracle,
that isn't on the best hardware either...
How many users are you serving from your desktop?
Ray,
You told me once of a way to clear out all cached queries at once, but
I'll be darned if I can find the thread.
Would you please repeat?
Thanks,
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
You told me once of a way to clear out all cached queries at
once, but I'll be darned if I can find the thread.
I'm not Ray, but:
cfobjectcache action="">
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
cfobjectcache if I am correct
Qasim
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 19, 2004 1:43 PM
To: CF-Talk
Subject: Clearing all Cached Queries (Attn: Ray C.)
Ray,
You told me once of a way to clear out all cached queries at once, but
I'll
Is there any rule of thumb or method for figuring out how to optimize
the number of queries to cache setting in Administrator?
Thanks,
Scott
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
From: Scott Mulholland
Is there any rule of thumb or method for figuring out how to
optimize the number of queries to cache setting in Administrator?
There is no hard and fast setting for this
It really depends on the applications you have running on your server,
how many queries you have
Are cached-queries cfapplication-name specific?I've got a web site running
a cf application (named myapp) and a related administrative application on
another web site (also myapp for the moment).I'd like to change the name
of the admin app so that admins aren't automatically logged
cached queries, via cachedwithin or cachedafter, are identified by their signature which is composed of query name, SQL, etc..I forget the exact qualities.These are cached regardless of the presence of a cfapplication, else you would be required to use one when caching.
Doug
-Original
Are cached-queries cfapplication-name specific?
No, they're not. They're identified by the SQL statement and the attributes
of the CFQUERY tag, excluding the CACHEDWITHIN/CACHEDAFTER attribute itself.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202
Thanks, Doug.That makes sense.
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 30, 2004 11:35 AM
Subject: RE: Cached Queries
cached queries, via cachedwithin or cachedafter, are identified by their
signature which is composed of query
It's a pretty simple matter to clear all the queries accessed in a
request, say by setting a clearcache url var, and writing the code
to set the cache span to a nil duration when url.clearcache exists.
Q1. However, what if I'd like to clear *all* cached queries in the
entire application in one
Q1. However, what if I'd like to clear *all* cached queries
in the entire application in one fell swoop? (Without a
server restart ;-)
cfobjectcache action="">
This clears the entire server's set of cached queries.
Q2. Also, say I've got a dynamic query...
cfquery ...se
Brilliant, thanks.
Jamie
On Tue, 6 Jan 2004 12:47:04 -0600, in cf-talk you wrote:
Q1. However, what if I'd like to clear *all* cached queries
in the entire application in one fell swoop? (Without a
server restart ;-)
cfobjectcache action="">
This clears the entire server's
Hello,
I have written a CFX custom tag for CFMX, called cfx_queryCache, which allows you to get a list of all your cached queries and flush individual queries based on its key.
I'd be interested in any ideas for improvements, both functionality and improving the Java code. It's open-source
I have tried using the undocumented cfset CFUSION_DBCONNECTIONS_FLUSH()but it is not flushing query results and forcing a new query (I want to flush the cached queryies whenever an administrator updates info in the database).Is there any other way to flush cached query results?I am using CF5 on
I thought that DBCOMMECTIONS_FLUSH only flushed the ODBC connectors, not
the cached queries
Anyways, the way I do it is to put a CreateTimeSpan(0,0,0,0) in the
CACHEDWITHIN, that tells CF to get the latest data
If you're using CACHEDWITHIN, then I'd suggest putting the time span
cfobjectcache action="">
Good luck,
-JSLucido
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:03 AM
To: CF-Talk
Subject: How do I flush cached queries?
I have tried using the undocumented cfset
CFUSION_DBCONN
, onTap.
Good luck,
-JSLucido
-Original Message-
From: Jeff Lucido [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:20 AM
To: CF-Talk
Subject: RE: How do I flush cached queries?
cfobjectcache action="">
Good luck,
-JSLucido
-Original Message-
From: Pet
I have the following query, however if I enter more than one value in the search form such as
Surname = Vaughan
Funding = budget
CFQUERY datasource=liv8 name=funding
SELECT * FROM funding
WHERE 1=1
cfif Len(Trim(form.orgname))
AND UPPER(orgname) LIKE UPPER(cfqueryparam cfsqltype=CF_SQL_VARCHAR
, October 10, 2003 9:18 AM
Subject: RE: How do I flush cached queries?
I thought that DBCOMMECTIONS_FLUSH only flushed the ODBC connectors, not
the cached queries
Anyways, the way I do it is to put a CreateTimeSpan(0,0,0,0) in the
CACHEDWITHIN, that tells CF to get the latest data
If you're using
queries?
cfobjectcache action="">
Good luck,
-JSLucido
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:03 AM
To: CF-Talk
Subject: How do I flush cached queries?
I have tried using the undocumented cfset
CFUSION_DBCONN
When using the cfobjectcache action=clear,
Does it flush just the cached queries in the application, or on all
applications across the server?
Thanks, Mark
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
When using the cfobjectcache action=clear,
Does it flush just the cached queries in the application,
or on all applications across the server?
It flushes all cached queries on the server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
Supposedly...I've never found that to be the case though. It only
seems to work at a template level for me, refreshing any cached
queries that are executed after the cfobjectcache statement during the
request. Any other cached queries for that application remain cached,
unaffected by cfobjectcache
Supposedly...I've never found that to be the case though.
It only seems to work at a template level for me, refreshing
any cached queries that are executed after the cfobjectcache
statement during the request. Any other cached queries for
that application remain cached, unaffected
-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 5:21 PM
To: CF-Talk
Subject: Re: Flushing All Cached Queries
Supposedly...I've never found that to be the case though. It only
seems to work at a template level for me, refreshing any
Thursday, February 27, 2003, 6:48:53 PM, you wrote:
Supposedly...I've never found that to be the case though.
It only seems to work at a template level for me, refreshing
any cached queries that are executed after the cfobjectcache
statement during the request. Any other cached queries
variable in the server scope that
lists the names of the cached queries?
Byron
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
cfquery.executionTime might be useful. In my experience it is 0 for
cached queries. However it might conceivably return 0 for non-cached
queries too.
Matthew Walker
http://www.matthewwalker.net.nz/
-Original Message-
From: Byron M [mailto:mbyron;comcast.net]
Sent: Tuesday, 29
or not, and the time since it was first cached, but all this code is
in a .cfc and I want to keep it portable as possible.
Byron Mann
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 28, 2002 4:47 PM
Subject: RE: Cached Queries
Nothing wrong with a cfc having access to persistent data...I'd say an
app variable is the best way to do this. Just make the cfc test to see
if 24 hours have passed between refreshes. Application variables
aren't the only way to make data persist...you could use a db, or the
filesystem.
Some
Hi.
I have a cached query, as below, which runs on a number of pages:
cfquery cachedwithin=#createtimespan(1,0,0,0)# name=findcats
datasource=#application.DSN#
SELECT sub_name,cat_name FROM categories, sub_cats
WHERE categories.ID = sub_cats.cat_id
ORDER by cat_name
/cfquery
The data in the
/using_recordsets.jsp
Stace
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 6:12 PM
To: CF-Talk
Subject: Making use of cached queries
Hi.
I have a cached query, as below, which runs on a number of pages:
cfquery cachedwithin=#createtimespan(1,0,0,0)# name
W Luke mailto:[EMAIL PROTECTED] wrote:
If I understand what you're asking you should be able to accomplish
that by using QueryOfQuery functionality which lets u use regular SQL
to query an existing recordset in memory.
Completely forgot about QoQ - been salivating over that for years, and
Try
Cfquery name=mytest dbtype=query maxrows=2
SELECT ProductName
FROM AllPaid
WHERE ProductID = 5
/CFQUERY
Ken
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 4:05 PM
To: CF-Talk
Subject: Re: Making use of cached queries
W Luke mailto
Ken Brocx [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Does it have a problem in calling TOP 2 records? For instance:
Try
Cfquery name=mytest dbtype=query maxrows=2
SELECT ProductName
FROM AllPaid
WHERE ProductID = 5
/CFQUERY
Thanks Ken. And last but not least, how
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 7:20 PM
Subject: Re: Making use of cached queries
Ken Brocx [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Does it have a problem in calling TOP 2 records? For instance:
Try
Cfquery name=mytest dbtype
Marius Milosav [EMAIL PROTECTED] wrote in message
news:000d01c26bf5$17838510$[EMAIL PROTECTED]...
replace the double quotes around Yes with single quotes 'Yes' and
it should run OK.
There shouldn't be any quotes, single or double - no need for them. I
tried single quotes anyway, and it
W Luke wrote:
Marius Milosav [EMAIL PROTECTED] wrote in message
news:000d01c26bf5$17838510$[EMAIL PROTECTED]...
replace the double quotes around Yes with single quotes 'Yes' and
it should run OK.
There shouldn't be any quotes, single or double - no need for them. I
tried single
PM
To: CF-Talk
Subject: Re: Making use of cached queries
Ken Brocx [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Does it have a problem in calling TOP 2 records? For instance:
Try
Cfquery name=mytest dbtype=query maxrows=2
SELECT ProductName
FROM AllPaid
WHERE ProductID
.
Hope that helps
Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
There is no spoon
-Original Message-
From: Tim Stadinski [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 22:12
To: CF-Talk
Subject: failed retrieval of cached queries
Has anyone seen the following error
: Alistair Davidson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 3:50 AM
To: CF-Talk
Subject: RE: failed retrieval of cached queries
Hi Tim
I don't know how much of this response will be relevant to your situation,
but here's how we managed to resolve this problem - (apologies if any
: RE: failed retrieval of cached queries
Of all the points you have made, I agree about the locking issues, but that
is not the case here. One point that I am curious about (6)If the cached
query is corrupt How can you determine if it is corrupt and what makes
a cached query corrupt?
Thanks
1 - 100 of 177 matches
Mail list logo