[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?

      <cfquery>INSERT INTO...</cfquery>
      <cfcatch type="database">
            <p>Oops! That didn't work</p>

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