[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowTables.cfm,1.1.1.1,1.2
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-04-12 04:19:27
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv10936 Modified Files: ShowTables.cfm Log Message: Cosmetic Change: [ 720058 ] Rename Table Links Index: ShowTables.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ShowTables.cfm 23 Mar 2003 03:44:34 -0000 1.1.1.1 --- ShowTables.cfm 12 Apr 2003 04:19:24 -0000 1.2 *************** *** 1,41 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowTables.cfm * ! * Purpose: Displays the Body Content for the ShowTables Database Process * ! * Requiremets: -tableList Query must be run on same page prior to including this template * ! * -dbGeneralInfo Query must be run on same page prior to including this * ! * template * ! * Todo: * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!---||| Show Tables in Current Database |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <tr><th colspan="3">Tables in Database:</th></tr> ! <tr> ! <th>Table Name</th> ! <th>Runs a SHOW FIELDS Query</th> ! <th>Runs Select Queries</th> ! </tr> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create List of Tables ---> ! <cfoutput query="tableList"> ! <tr><!--- Detail: ! The tableList query creates a recordset with the column name TABLES_IN_MyDatabase ! where MyDatabase is the name of the database currently in use. Since this variable ! name is not known until run time, we need a Dynamic Variable name called: ! TABLES_IN_#dbGeneralInfo.dbInUse# ! ---> ! <!--- Show Table Name ---> ! <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to Table Fields and Properties ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">Table Fields with Properties</a></td> ! <!--- Link to Select Fields and Records ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Selected Fields and Records</a></td> ! </tr> ! </cfoutput> ! </cflock> ! <!--- Link to create a new table ---> ! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr> </table> --- 1,41 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowTables.cfm * ! * Purpose: Displays the Body Content for the ShowTables Database Process * ! * Requiremets: -tableList Query must be run on same page prior to including this template * ! * -dbGeneralInfo Query must be run on same page prior to including this * ! * template * ! * Todo: * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!---||| Show Tables in Current Database |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <tr><th colspan="3">Tables in Database:</th></tr> ! <tr> ! <th>Table Name</th> ! <th>Runs a SHOW FIELDS Query</th> ! <th>Runs Select Queries</th> ! </tr> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create List of Tables ---> ! <cfoutput query="tableList"> ! <tr><!--- Detail: ! The tableList query creates a recordset with the column name TABLES_IN_MyDatabase ! where MyDatabase is the name of the database currently in use. Since this variable ! name is not known until run time, we need a Dynamic Variable name called: ! TABLES_IN_#dbGeneralInfo.dbInUse# ! ---> ! <!--- Show Table Name ---> ! <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to Table Fields and Properties ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td> ! <!--- Link to Select Fields and Records ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td> ! </tr> ! </cfoutput> ! </cflock> ! <!--- Link to create a new table ---> ! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr> </table> |