Tag Archives: maxRows

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