View comments | RSS feed
Contents > CFML Reference > Reserved Words and Variables > ColdFusion tag-specific variables > CFQUERY and CFSTOREDPROC variables PreviousNext

CFQUERY and CFSTOREDPROC variables

The cfquery tag returns information about the query in this variable:

CFQUERY.ExecutionTime

The cfquery tag uses the query name to scope the following data about the query:

queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList

The cfstoredproc tag returns the following variables:

CFSTOREDPROC.ExecutionTime
CFSTOREDPROC.StatusCode
Contents > CFML Reference > Reserved Words and Variables > ColdFusion tag-specific variables > CFQUERY and CFSTOREDPROC variables PreviousNext

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Comments


lhoess said on Nov 25, 2003 at 3:30 PM :
How do I access this variable? CFQUERY.ExecutionTime
I tried the queryname, but that didn't work.
incubus said on Nov 28, 2003 at 6:00 PM :
Now in CFMX we dont get the Out of errors while trying to access the Records which are not in the Query ..For Example:
<CFQUERY name="queryname">
select top 1 columnname from table
</CFQUERY>
<CFOUTPUT>#queryname.columnname[1000]#</CFOUTPUT>
The above code will be giving an exception or error in the CF5 but in CFMX the error is subdued..
jrunrandy said on Dec 1, 2003 at 6:09 AM :
Just use CFQUERY.ExecutionTime.

Just like any other variable, it has to be in ## and wrapped in cfoutput:

This example is similar to that on http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/debug22.htm:

<cfquery name="MyDBQuery" datasource="CompanyInfo">
SELECT *
FROM Employee
</cfquery>
<cfoutput>
completed query MyDBQuery; Query Execution time:
#cfquery.ExecutionTime#
</cfoutput>
No screen name said on Feb 18, 2005 at 3:45 AM :
how to get the execution time for any .cfm page?
jrunrandy said on Feb 18, 2005 at 5:32 AM :
If you enable debugging in the ColdFusion MX Administrator, you should see the information you are looking for. For an overview, go to http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm.

In a development environment, I typically enable everything.
mediamavenX said on Mar 14, 2005 at 12:31 PM :
can i show whole page (not just query) execution time without degug turned on? suppose i want to have it as a little 'gee whiz, look how fast that was' feature on a page.
No screen name said on Jul 23, 2005 at 7:10 AM :
how to get the execution time for any .cfm page?

in application.cfm
<cfset timeExePage = getTickCount()>

in onRequestEnd.cfm
<cfset timeExePage = getTickCount() - timeExePage >
<cfoutput><hr>#timeExePage#</cfoutput>

 

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/expres25.htm