Thread: How to check if a guery returns something

I am querying a database and want to know if a row is returned before I print anything, how do I do this in cold fusion?

thanks

Generally you use the query's "recordCount" variable.

<cfquery name="yourQueryName" datasource="...">
SELECT Something FROM SomeTable
</cfquery>

<cfif yourQueryName.recordCount GT 0>
query contains (1) or more records
<cfelse>
query contains (0) records
</cfif>