[thelist] ColdFusion & MSAccess - How do I check if a

Joshua Olson joshua at alphashop.net
Sat Apr 21 18:31:54 CDT 2001


Jon,

You are correct, it will look something like this:

<cftry>
  <cfquery name="myquey" datasource="myds" dbtype="ODBC">
    CREATE TABLE mytable (
      ... fields ...
    )
  </cfquery>

  <cfcatch type="Database">
    whoops, table must already exist.<hr>
    <cfoutput>
      <b>#cfcatch.message#</b><br>
      #cfcatch.detail#
    </cfoutput>
    <hr>
  </cfcatch>
</cftry>

-joshua


> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> Subject: RE: [thelist] ColdFusion & MSAccess - How do I check if a 
> 
> 
> Thanks Joshua,
> 
> So if I surround it with cftry and
> cfcatch-type=database it will continue with the code
> regardless of an error message?
> 
> Regards,
> Jon.





More information about the thelist mailing list