>>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 http://www.co
>>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:
SELECT * from events
h, or onerror()?
>
> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 11, 2007 8:11 AM
> To: CF-Talk
> Subject: Re: Finding current queries
>
> >>
>
>
>
> #i#: #variables[i].recordcount# records
>
PROTECTED]
Sent: Monday, June 11, 2007 8:11 AM
To: CF-Talk
Subject: Re: Finding current queries
>>
#i#: #variables[i].recordcount# records
~|
C
>>
#i#: #variables[i].recordcount# records
>>That code would assume the queries existed in the variables scope and
had been run on that page.
Exact, but even so, it appears that the variable scope itself is not
avail
our website at http://www.reedexpo.com
>
> -Original Message-
> From: Andrew Scott
> To: CF-Talk
> Sent: Mon 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
1 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 a seerve
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 in
: 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.
The SQL query may be not active, b
>>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
> 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 deskt
>>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 wi
-Talk
Sent: 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
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
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
ay, June 07, 2007 2:16 PM
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 li
>>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.
--
__
anything other than 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 temp
>>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.
--
__
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
Claude Schneegans [mailto:[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 applicati
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
22 matches
Mail list logo