RE: testing for existence of table

2000-06-28 Thread Philip Arnold - ASP
> I have a temporary table that needs to be deleted after > processing has completed. But, if the user bails and doesn't > complete the transaction, the temporary table doesn't get deleted, > which causes an error message when CF attempts to create the > table later on. So I put in some code to

RE: testing for existence of table

2000-06-27 Thread Mark Warrick
Use CFCATCH, and catch any database error. If one comes up you know you need to drop the table and recreate it. (using a conditional statement, of course) ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Per