[thelist] ColdFusion query questions

[Matt Shooks]

>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