View comments | RSS feed
Developing ColdFusion MX Applications with CFML Previous Up One Level Next
Accessing and Retrieving Data


Getting information about query results

Each time you query a database with the cfquery tag, you get the data (the record set) and the query variables; together these comprise the query object. The following table describes the query variables, which are sometimes referred to as query properties:
Variable
Description
RecordCount
The total number of records returned by the query.
ColumnList
A comma-delimited list of the query columns, in alphabetical order.
CurrentRow
The current row of the query being processed by cfoutput.

In your CFML code, you can use these variables as if they were columns in a database table.

To output the query record count on your page:

  1. Edit emplist.cfm so that it appears as follows:
    <html>
<head>
<title>Employee List</title>
</head>
<body>
<h1>Employee List</h1>
<cfquery name="EmpList" datasource="CompanyInfo">
  SELECT FirstName, LastName, Salary, Contract
  FROM Employee
</cfquery>
<cfoutput query="EmpList">
  #EmpList.FirstName#, #EmpList.LastName#, #EmpList.Salary#, #EmpList.Contract#<br>
</cfoutput>
<br>
<cfoutput>
  The query returned #EmpList.RecordCount# records.
</cfoutput>
</body>
</html>
  2. Save the file and view it in your web browser:

    Query output from the cfoutput tag in a browser including the record count

    The number of employees now appears below the list of employees. You might have to refresh your browser and scroll to see the RecordCount output.

Note:   The variable cfquery.executionTime contains the amount of time, in milliseconds, it took for the query to complete. Do not prefix the variable name with the query name.

Reviewing the code

You now display the number of records retrieved in the query. The following table describes the code and its function:
Code
Description
 
<cfoutput>
Displays what follows.
 
The query returned
Displays the text "The query returned".
 
#EmpList.RecordCount#
Displays the number of records retrieved in the EmpList query.
 
records.
Displays the text "records..
 
</cfoutput>
Ends the cfoutput block.

Query variable notes and considerations

When using query variables, keep the following guidelines in mind:

Previous Up Next

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

Version 6

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

Comments


killher said on Aug 19, 2004 at 11:48 PM :
Is There Any Way to Retreive Query Result (Recordset)
By Using Colum Index?
Just Like
<cfoutput> queryname(columnIndex)
No screen name said on Dec 31, 2004 at 11:02 AM :
Perhaps you can get the list of the column names and then at each iteration somewhere, set columnVariable(below) to a member of that list.
<CFOUTPUT query="MYQUERY">
<CFSET myString= listGetAt(...)>
<CFSET columnVariable = "QUERYRESULT.#myString#"
#evaluate(columnVariable)#
</CFOUTPUT>
No screen name said on Dec 31, 2004 at 11:04 AM :
Sorry, I meant:

<CFOUTPUT query="MYQUERY">
<CFSET myString = listGetAt(...)>
<CFSET columnVariable ="MYQUERY.#myString#"
#evaluate(columnVariable)#
</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/Developing_ColdFusion_MX_Applications_with_CFML/queryDB5.htm