RE: Does table exist?
Run your drop table query the table within a cftry. That'll catch any errors that would be thrown due to the table not existing. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 28, 2004 9:48 AM To: CF-Talk Subject: Does table exist? I am looking for a way to determine if a table exists so I can then decide what action to take. I have been unable to find away to do this with an Access Macro, so now am trying to achieve the same results within CF. I run a macro within Access that Deletes a table and then runs a Make Table Query. My problem is if I have a problem the table gets deleted and the next time the macro runs and errors out as it has no table to delete. If I knew up front whether the table exists I wouldn't try and delete it, just create the new one, If I could do this within Access it would be easier. If I could do this from CF I could achieve the same results as well. Sure would appreciate some suggestions here. BTW The reason for all this is MAS90's Providex driver will not allow me to access their tables in either a linked table in Access or directly via ODBC. Do I create a link in Access and on a schedule I run a batch file that opens Access from the command line and runs the macro that deletes, and then does a make table from the linked table. Then it compresses the database to help keep the database size manageable. This works flawlessly 98 per cent of the time for the past year or so. I want to cover my butt for the remaining 2 per cent. Terry Troxel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Does there exist...
If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Does there exist...
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=mailing.database.sql-general this would be your best bet. Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 -- -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Does there exist...
http://www.sswug.org/ Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Does there exist...
We have such a list on HoF. It's low traffic but has enough people to handle almost all SQL questions. subscribe: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/sql archives: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=6 Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm