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

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

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

Modified Files:
	tableList.cfm 
Log Message:
Internal Structure Changed:
[ 737437 ] Convert Query/tableList.cfm to a CUSTOM TAG

Index: tableList.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/tableList.cfm,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** tableList.cfm	13 Apr 2003 05:36:53 -0000	1.1
--- tableList.cfm	14 May 2003 03:23:17 -0000	1.2
***************
*** 1,15 ****
  <!---*******************************************************************************************
  * 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>
\ No newline at end of file
--- 1,23 ----
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/tableList.cfm (CUSTOM TAG)                                           *
! * Purpose:          Creates a Record Set with a list of table names for the requested database *
! * Inputs:           - queryName (Required)                                                     *
! *                   - dataSource (Required)                                                    *
! *                   - userName (Required)                                                      *
! *                   - password (Required)                                                      *
! * Outputs:          - queryName                                                                *
  ********************************************************************************************--->
  
! <!---||| Check for existence of Required Attributes |||--->
! <!---||| More user friendly error checking will be introduced in the BETA releases |||--->
! <cfif NOT IsDefined("ATTRIBUTES.queryName")><CFABORT showerror="The queryName attribute is required when calling tableList custom tag."></cfif>
! <cfif NOT IsDefined("ATTRIBUTES.dataSource")><CFABORT showerror="The dataSource attribute is required when calling tableList custom tag."></cfif>
! <cfif NOT IsDefined("ATTRIBUTES.userName")><CFABORT showerror="The userName attribute is required when calling tableList custom tag."></cfif>
! <cfif NOT IsDefined("ATTRIBUTES.password")><CFABORT showerror="The password attribute is required when calling tableList custom tag."></cfif>
! 
! <!---||| Find out the list of Tables in the Passed Database |||--->
! <!--- Create Recordset with a List of Table Names --->
! <cfquery name="CALLER.#ATTRIBUTES.queryName#" datasource="#ATTRIBUTES.dataSource#" username="#ATTRIBUTES.userName#" password="#ATTRIBUTES.password#">
! 	SHOW TABLES;
! </cfquery>
\ No newline at end of file