For years I’ve never been aware of a method to return only so many rows to the ColdFusion memory space using dbtype=”query”. I’ve always just ran the query then limited it down the code with things like <cfoutput query=”q” maxrows=”1″>.

In a MSSQL query, you can limit the query like: SELECT TOP 1 FROM TABLE

This will not work with a query of queries.

Today I found a solution…

Move the maxrows attribute to the cfquery tag. For example: <cfquery name=”q” dbtype=”query” maxrows=”1″> will return only the first row back to the memory space.