[Mydatabasepilot-cvs] MyDatabasePilot/Query tableList.cfm,NONE,1.1

[<nan...@us...>]

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv12055

Added Files:
	tableList.cfm 
Log Message:
Functionality Added: [ 720522 ] Create a New File Query/tableList.cfm

--- NEW FILE: tableList.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         Query/tableList.cfm                                                        *
* Purpose:          Creates a Record Set with a list of tables in the current database         *
* Requiremets:      Connection Variables must already be set                                   *
********************************************************************************************--->

<!---||| Find out the list of Tables in the Current Database |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
	<!--- Create Recordset with a List of Table Names --->
	<cfquery name="tableList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
		SHOW TABLES;
	</cfquery>
</cflock>