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
|
