and you have to use try/catch don't do "select *". It can possibly
return a lot of info. You could use select count(*). In your catch use
type="Database" and try to find the correct errorcode for a non-existing
table.
Pascal
> -----Original Message-----
> From: Robertson-Ravo, Neil (RX)
> [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 8 juni 2004 14:27
> To: CF-Talk
> Subject: RE: checking if a table exists?
>
> Well, in CF you would and could make a call to the table
> name, but place it in a cftry block and getting the result
>
>
>
> try
>
> SELECT * FROM YOURTABLE
>
> catch
>
> your code to check if it exists
>
> /catch
>
> /try
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
