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

[jon steele]

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.

"Jon,

You do not need to skip the query, really.  You can
try to create the 
table
again and then trap the database error via <cftry> and
<cfcatch>.  This
technique is nice because it'll work with any database
that is capable 
of
throwing an error under such circumstances.

The other technique (like you are requesting) is to
query the system 
tables
for the object.  So, you are adding another select
query to the mix at
minimum.  So, the create+catch method may be quicker
in the long run.

-joshua"


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/