[thelist] ColdFusion query questions
Matt Shooks
shooksm at hotmail.com
Wed Dec 3 18:09:52 CST 2003
>For instance, if I want to SELECT and see if there was any matching rows?
<query name here>.RecordCount
>How do I loop/test them without outputting them?
<cfloop qruery="Query Name Here"></cfloop>
>What if I did an INSERT
>that failed due to a table constraint, how do I test for that?
<cftry>
<cfquery>INSERT INTO...</cfquery>
<cfcatch type="database">
<p>Oops! That didn't work</p>
</cfcatch>
</cftry>
_________________________________________________________________
Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6
months @ $9.95/month now! http://join.msn.com/?page=dept/dialup
More information about the thelist
mailing list