[thelist] ColdFusion query questions

Pete Freitag pf at cfdev.com
Wed Dec 3 17:10:45 CST 2003


Kelly Hallman wrote:

>Just a couple of quick/easy CF questions (long story, but I'm hacking a CF 
>version of another web app very quickly, and I don't know CF)...
>
>I understand how to run a query with CFQUERY, and how to output the 
>results with CFOUTPUT ... how do I check/manipulate the results, and/or 
>know if there were any results, or if there was a query error?
>  
>
>For instance, if I want to SELECT and see if there was any matching rows?  
>How do I loop/test them without outputting them? What if I did an INSERT
>that failed due to a table constraint, how do I test for that?
>
>By the way, this is CF version 5 on Linux.
>Thank you very much!!
>
>  
>
Hi Kelly,

To check and see if the query returned any results you can use the 
variable yourqueryname.recordcount, so something like this would see if 
no results were returned:
<cfif yourquery.recordcount eq 0>
    Sorry no results.
</cfif>

If the query generates an error an exception is thrown, if the exception 
is not caught then the error message is displayed, or you can catch the 
error like this:

<cftry>
    <cfquery > ... </cfquery>
    <cfcatch type="database">
       There was an error in your database query: <cfdump var="#cfcatch#">
    </cfcatch>
</cftry>

___________________________________
Pete Freitag
CTO, CFDEV.COM
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/




More information about the thelist mailing list