[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.21,1.22
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-05-27 04:03:17
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv13998 Modified Files: MyDatabasePilot.cfm Log Message: Functionality Added: [ 744006 ] Added File dbProcessInit/AddField.cfm - Calls Custom Tag Query/fieldList.cfm Included dbProcessInit/AddField.cfm in Initialization Switch of MyDatabasePilot.cfm Index: MyDatabasePilot.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** MyDatabasePilot.cfm 25 May 2003 16:18:59 -0000 1.21 --- MyDatabasePilot.cfm 27 May 2003 04:03:14 -0000 1.22 *************** *** 1,66 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: MyDatabasePilot.cfm * ! * Purpose: DataBase Administrator Page, this is where the bulk of the processing * ! * calls are made from * ! * Requiremets: The database connection variables must either be configured in the * ! * Aplication.cfm file, or passed to this template via FORM_LogintoDB * ! ********************************************************************************************---> ! ! <!-----------------------------------------------> ! <!--- Initialize dbProcess ---> ! <!--- Process User Request Input Variables ---> ! <!--- Initialize Internal Variables and ---> ! <!--- Run Requested Database Command or Query ---> ! <!-----------------------------------------------> ! <!---||| Which dbProcess was requested? Include Initialization Files based on dbProcess |||---> ! <cfswitch expression="#dbProcess#"> ! <cfcase value="ShowTables"><cfinclude template="dbProcessInit/ShowTables.cfm"></cfcase> ! <cfcase value="ShowFields"><cfinclude template="dbProcessInit/ShowFields.cfm"></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="dbProcessInit/ShowRecords.cfm"></cfcase> ! <cfcase value="AddField"></cfcase> ! <cfcase value="AlterField"></cfcase> ! <cfcase value="DropField"></cfcase> ! <cfcase value="CreateTable"></cfcase> ! <cfcase value="AlterTable"></cfcase> ! <cfcase value="RenameTable"></cfcase> ! <cfcase value="DropTable"></cfcase> ! <cfcase value="Select"></cfcase> ! <cfcase value="Insert"></cfcase> ! <cfcase value="Update"></cfcase> ! <cfcase value="Delete"></cfcase> ! </cfswitch> ! ! <!-----------------------------------------> ! <!--- Output the Result of User Request ---> ! <!-----------------------------------------> ! <!---||| Include Header |||---> ! <cfinclude template="Include/Header.cfm"> ! ! <!---||| Show Current Database |||---> ! <!--- Initiate a readonly lock to ensure the integrity of session variables ---> ! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> ! <h2>Current Database: <cfoutput>#session.dbName#</cfoutput></h2> ! </cflock> ! ! <!---||| Output the Result of User Requested dbProcess |||---> ! <cfswitch expression="#dbProcess#"> ! <cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase> ! <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm"></cfcase> ! <cfcase value="AddField"><cfinclude template="dbProcessBody/AddField.cfm"></cfcase> ! <cfcase value="AlterField">Alter Field</cfcase> ! <cfcase value="DropField">Drop Field</cfcase> ! <cfcase value="CreateTable">Create Table</cfcase> ! <cfcase value="AlterTable">Alter Table</cfcase> ! <cfcase value="RenameTable">Rename Table</cfcase> ! <cfcase value="DropTable">Drop Table</cfcase> ! <cfcase value="Select">Select</cfcase> ! <cfcase value="Insert">Insert</cfcase> ! <cfcase value="Update">Update</cfcase> ! <cfcase value="Delete">Delete</cfcase> ! <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> ! </cfswitch> ! ! <!---||| Include Footer |||---> ! <cfinclude template="Include/Footer.cfm"> \ No newline at end of file --- 1,66 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: MyDatabasePilot.cfm * ! * Purpose: DataBase Administrator Page, this is where the bulk of the processing * ! * calls are made from * ! * Requiremets: The database connection variables must either be configured in the * ! * Aplication.cfm file, or passed to this template via FORM_LogintoDB * ! ********************************************************************************************---> ! ! <!-----------------------------------------------> ! <!--- Initialize dbProcess ---> ! <!--- Process User Request Input Variables ---> ! <!--- Initialize Internal Variables and ---> ! <!--- Run Requested Database Command or Query ---> ! <!-----------------------------------------------> ! <!---||| Which dbProcess was requested? Include Initialization Files based on dbProcess |||---> ! <cfswitch expression="#dbProcess#"> ! <cfcase value="ShowTables"><cfinclude template="dbProcessInit/ShowTables.cfm" /></cfcase> ! <cfcase value="ShowFields"><cfinclude template="dbProcessInit/ShowFields.cfm" /></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="dbProcessInit/ShowRecords.cfm" /></cfcase> ! <cfcase value="AddField"><cfinclude template="dbProcessInit/AddField.cfm" /></cfcase> ! <cfcase value="AlterField"></cfcase> ! <cfcase value="DropField"></cfcase> ! <cfcase value="CreateTable"></cfcase> ! <cfcase value="AlterTable"></cfcase> ! <cfcase value="RenameTable"></cfcase> ! <cfcase value="DropTable"></cfcase> ! <cfcase value="Select"></cfcase> ! <cfcase value="Insert"></cfcase> ! <cfcase value="Update"></cfcase> ! <cfcase value="Delete"></cfcase> ! </cfswitch> ! ! <!-----------------------------------------> ! <!--- Output the Result of User Request ---> ! <!-----------------------------------------> ! <!---||| Include Header |||---> ! <cfinclude template="Include/Header.cfm" /> ! ! <!---||| Show Current Database |||---> ! <!--- Initiate a readonly lock to ensure the integrity of session variables ---> ! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> ! <h2>Current Database: <cfoutput>#session.dbName#</cfoutput></h2> ! </cflock> ! ! <!---||| Output the Result of User Requested dbProcess |||---> ! <cfswitch expression="#dbProcess#"> ! <cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm" /></cfcase> ! <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm" /></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm" /></cfcase> ! <cfcase value="AddField"><cfinclude template="dbProcessBody/AddField.cfm" /></cfcase> ! <cfcase value="AlterField">Alter Field</cfcase> ! <cfcase value="DropField">Drop Field</cfcase> ! <cfcase value="CreateTable">Create Table</cfcase> ! <cfcase value="AlterTable">Alter Table</cfcase> ! <cfcase value="RenameTable">Rename Table</cfcase> ! <cfcase value="DropTable">Drop Table</cfcase> ! <cfcase value="Select">Select</cfcase> ! <cfcase value="Insert">Insert</cfcase> ! <cfcase value="Update">Update</cfcase> ! <cfcase value="Delete">Delete</cfcase> ! <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> ! </cfswitch> ! ! <!---||| Include Footer |||---> ! <cfinclude template="Include/Footer.cfm" /> \ No newline at end of file |