TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Talk
Cold Fusion - Technical

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Talk:
Subject: RE: existence of table

Peter Stolz (16p/+0r) Posted: Thursday 12 Apr 2001
This post: 80 views, +0 rating

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'events0301'

HTH, P.

-----Original Message----- From: Diana Nichols [mailto:nichols2000@mindspring.com] Sent: Thursday, April 12, 2001 11:07 AM To: CF-Talk Subject: existence of table

Is there a way to check for the existence of a database table (SQL 2000)?

I have a calendar which stores each month's events in a separate table (events0301), and if the user hits the "last month" button past where the tables start, it throws an error.

I tried a cftry/cfcatch on the query, but....To complicate matters, I'm using a UNION on "this" month and "last" month to show any events not cleared from the previous month. So, the first table is events0301, and the cftry/cfcatch scenario won't let them view events from March because February table doesn't exist.

Insights, suggestions?

as always, TIA!!

Diana

************* Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

Similar Subject Line Posts (+/- two weeks of this post)

RE: existence of table	12 Apr 2001	(56 v/ +0 r)
RE: existence of table	12 Apr 2001	(55 v/ +0 r)
RE: existence of table	12 Apr 2001	(52 v/ +0 r)
RE: existence of table	12 Apr 2001	(51 v/ +0 r)
RE: existence of table	12 Apr 2001	(50 v/ +0 r)
RE: existence of table	12 Apr 2001	(60 v/ +0 r)
RE: existence of table	12 Apr 2001 (this post)	(80 v/ +0 r)
RE: existence of table	12 Apr 2001	(54 v/ +0 r)
existence of table	12 Apr 2001	(51 v/ +0 r)

Send a reply to the CF-Talk list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)