|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Check if table already exists?
I'm running a query where sometimes the table being created or copied might already exists. CF throws an error if this happens. How can I check it via cfif or cfloop before performing the query?
Thanks to all here for your help! |
|
#2
|
|||
|
|||
|
You can wrap the code with cftry/cfcatch to catch an error that arises when the table already exists and perform whatever other processing you need to (or do nothing).
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums |
|
#3
|
|||
|
|||
|
Thanks - worked great!
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Check if table already exists? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|