[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowTables.cfm,1.2,1.3
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-04-13 03:41:31
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv17452 Modified Files: ShowTables.cfm Log Message: Cosmetic Change: [ 720507] Drop Table, Alter Table Place holders Index: ShowTables.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** ShowTables.cfm 12 Apr 2003 04:19:24 -0000 1.2 --- ShowTables.cfm 13 Apr 2003 03:41:28 -0000 1.3 *************** *** 12,20 **** <!---||| 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 ---> --- 12,18 ---- <!---||| Show Tables in Current Database |||---> <table width="100%" border="1" cellspacing="0" cellpadding="2"> <tr> <th>Table Name</th> ! <th colspan="4">Commands</th> </tr> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> *************** *** 30,41 **** <!--- 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> \ No newline at end of file --- 28,45 ---- <!--- Show Table Name ---> <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to Show 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 Show Records ---> <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td> + <!--- Link to Alter Table---> + <td>Alter Table</td> + <!--- Link to Drop Table ---> + <td>Drop Table</td> </tr> </cfoutput> </cflock> + </table> + + <!---||| Add New Table |||---> <!--- Link to create a new table ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock> \ No newline at end of file |