Category Archives: CFQUERY

Getting a list of columns returned by a CFQUERY tag in ColdFusion

In a previous example, “Determining the number of results from a database query in ColdFusion”, we saw how you could get the number of records returned by a database query in ColdFusion by using the recordCount property on the query object.

The following example shows how you can get a list of columns in a data query object in ColdFusion by using the columnList property.

Continue reading Getting a list of columns returned by a CFQUERY tag in ColdFusion

Specifying a maximum number of results from a query using the CFQUERY tag in ColdFusion

In a previous example, “Querying a database in ColdFusion using the CFQUERY tag”, we saw how you could query a database in ColdFusion 9 using the <CFQUERY> tag.

The following example shows how you can restrict the number of results from a database query by setting the maxRows attribute on the <CFQUERY> tag in ColdFusion.

Continue reading Specifying a maximum number of results from a query using the CFQUERY tag in ColdFusion

Determining the number of results from a database query in ColdFusion

In a previous example, “Querying a database in ColdFusion using the CFQUERY tag”, we saw how you could query a database in ColdFusion 9 using the <CFQUERY> tag.

The following example shows how you can get the number of records returned by a database query in ColdFusion by using the recordCount property on the query object.

Continue reading Determining the number of results from a database query in ColdFusion