I am trying to use cfquery to drop a table. That works fine.\
Problem:
If I run the DROP TABLE on a database where the table is already gone I get
a nasty SQL error. Is there a simple way to check for the existance of the
table, and if present, then drop it? My mind is mush right now and I cannot
figure this one out. Thank all.
Regards,
Gary McNeel, Jr.
DACNet Project Manager
Research and Graduate Studies
Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists