The cftry works a treat. thank you
-----Original Message-----
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 14:21
To: CF-Talk
Subject: RE: Check for table existence??
This query will return a list of tables in your datasource.
<cfquery name="qryTables" datasource="#locDatasource#">
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_Name <> 'dtproperties'
</cfquery>
Justin Hansen
--------------------------
Uhlig Communications
Web Developer / Programmer
--------------------------
[EMAIL PROTECTED]
913-754-4273
--------------------------
-----Original Message-----
From: Jason Congerton - Mcaonline
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 7:52 AM
To: CF-Talk
Subject: Check for table existence??
Dear ALL
A bit new to all this..
Can you check to see if a table exists within a database with cold fusion?
If so can someone tell me how please.
The reason for this, is one part of my database copies a table into another
which is name uniquley by a the users id, however this table needs to be
deleted once the user has logged off, problem being if the user does not log
off correctly the table will still be there, so I need to be check for
existence and delete at the logon stage.
Regards
Jason
This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]
Whilst every endeavour is taken to ensure that e-mails are free from
viruses, no liability can be accepted and the recipient is requested
to use their own virus checking software.
______________________________________________________________________
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
