:[EMAIL PROTECTED]
Sent: Saturday, June 09, 2007 3:09 PM
To: CF-Talk
Subject: Re: Finding current queries
Ok, I'm still a little confused. If the query is still active then
the
result set wouldn't be defined yet.
Brad, I'm talking of CF queries objects, not SQL queries in the database
engine itself
I think the best way for such an answer would be to look at a server
monitor, CF8 has this ability and so does Fusion Reactor
which is also great for threads an other things as well. Which is the best
form of debugging you can buy, from a seerver point of view.
But unless the queries are stored
2007
Subject: Re: Finding current queries
I think the best way for such an answer would be to look at a server
monitor, CF8 has this ability and so does Fusion Reactor
which is also great for threads an other things as well. Which is the best
form of debugging you can buy, from a seerver point
Jun 11 08:03:41 2007
Subject: Re: Finding current queries
I think the best way for such an answer would be to look at a server
monitor, CF8 has this ability and so does Fusion Reactor
which is also great for threads an other things as well. Which is the best
form of debugging you can buy, from
cfoutput
cfloop collection=#variables# item=i
cfif isquery(variables[i])
#i#: #variables[i].recordcount# recordsbr
/cfif
/cfloop
/cfoutput
That code would assume the queries existed in the variables scope and
had been run
]
Sent: Monday, June 11, 2007 8:11 AM
To: CF-Talk
Subject: Re: Finding current queries
cfoutput
cfloop collection=#variables# item=i
cfif isquery(variables[i])
#i#: #variables[i].recordcount# recordsbr
/cfif
/cfloop
/cfoutput
at the time of your error.
-- Josh
- Original Message -
From: Brad Wood [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, June 11, 2007 7:50 AM
Subject: RE: Finding current queries
I think I see what you are saying now. You want to examine the query
objects
I think this thread was discussed before, and you can't get the
variables
scope in onError or with cferror.
Exact, I was the one to asked the question.
However, I just found that the request scope is available from the
CFERROR template.
For instance, this works:
CFERROR TYPE=EXCEPTION
How are you trapping the errors? Cfcatch, or onerror()?
I use CFCATCH for all errors that could normally happen, ie: CFHTTP on a
site which does not respond.
I use CFERROR for all unexpected errors.
--
___
REUSE CODE! Use custom tags;
See
If you need to do performance analysis this indepth,
This is not what I need, I just need to check if queries currently
defined in the CF application
returned records or not in case of error.
you should definately not be using MS Access! It's a DESKTOP DATABASE!
Please give me a break with
This is not what I need, I just need to check if queries
currently defined in the CF application returned records or
not in case of error.
Could you solve this problem by adding logging logic to your application?
Please give me a break with this urban legend:
1º Access.exe IS a desktop
Ok, I'm still a little confused. If the query is still active then the
result set wouldn't be defined yet.
Brad, I'm talking of CF queries objects, not SQL queries in the database
engine itself.
The SQL query may be not active, but there is still a query object
defined in the CF application.
Seefusion/Fusion Ractor - or you could use query analyzer to sp_lock2 and
then dbcc inputbuffer on the spid to see what the sp is that is running.
On 6/7/07, Rick Root [EMAIL PROTECTED] wrote:
On 6/7/07, Claude Schneegans [EMAIL PROTECTED] wrote:
Depending on your database, just run a
: Fri Jun 08 16:59:24 2007
Subject: Re: Finding current queries
Seefusion/Fusion Ractor - or you could use query analyzer to sp_lock2 and
then dbcc inputbuffer on the spid to see what the sp is that is running.
On 6/7/07, Rick Root [EMAIL PROTECTED] wrote:
On 6/7/07, Claude Schneegans [EMAIL
Hi,
Beside declaring them in the session scope, is there any mean to find
all currently active queries in an application?
Both in CFMX and CF 5 ?
~|
CF 8 â Scorpio beta now available,
easily build great internet experiences
:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 12:57 PM
To: CF-Talk
Subject: Finding current queries
Hi,
Beside declaring them in the session scope, is there any mean to find
all currently active queries in an application?
Both in CFMX and CF 5
PROTECTED]
Sent: Thursday, June 07, 2007 1:57 PM
To: CF-Talk
Subject: Finding current queries
Hi,
Beside declaring them in the session scope, is there any mean to find
all currently active queries in an application?
Both in CFMX and CF 5
Not sure what you mean? Are you trying to get a report of every
currently running template which is querying the database at that point
in time?
Exact, I'd like to list all active queries in my onError template,
together with the number of records found.
This could help for debugging.
--
MS SQL.
~Brad
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 1:58 PM
To: CF-Talk
Subject: Re: Finding current queries
Not sure what you mean? Are you trying to get a report of every
currently running template which is querying
If the query is still active, you wouldn't know how many records had
been returned because it
wouldn't have returned yet.
I just mean defined in CF
Depending on your database, just run a query like what I had suggested.
I don't think this is possible with Access databases.
--
To: CF-Talk
Subject: Re: Finding current queries
If the query is still active, you wouldn't know how many records had
been returned because it
wouldn't have returned yet.
I just mean defined in CF
Depending on your database, just run a query like what I had
suggested.
I don't think
On 6/7/07, Claude Schneegans [EMAIL PROTECTED] wrote:
Depending on your database, just run a query like what I had suggested.
I don't think this is possible with Access databases.
If you need to do performance analysis this indepth, you should
definately not be using MS Access! It's a
22 matches
Mail list logo
