[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.3,1.4

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed: [ 720529 ] Set up a CFSwitch for dbProcess Queries

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** MyDatabasePilot.cfm	13 Apr 2003 04:36:33 -0000	1.3
--- MyDatabasePilot.cfm	13 Apr 2003 06:15:21 -0000	1.4
***************
*** 2,12 ****
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
  * Template:         MyDatabasePilot.cfm                                                        *
! * Purpose:          DataBase Administrator Page, allows for table views, edits,                *
! *                   updates, and deletes in MySQL Databases                                    *
! *                   Basically this is a GUI for MySQL Databases written in ColdFusion          *
  * Requiremets:      The database connection variables must either be configured in the         *
! *                   Aplication.cfm file, or passed to this template via FORM_LogintoDB.        *
! * Todo:                                                                                        *
! * Known Issues/Bugs:                                                                           *
  ********************************************************************************************--->

--- 2,9 ----
  * 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         *
  ********************************************************************************************--->

***************
*** 28,45 ****
  
  <cfinclude template="Query/dbGeneralInfo.cfm">
! 
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
! 	
! 	<cfif dbProcess IS "ShowTables">
! 		<cfquery name="tableList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
! 			SHOW TABLES;
! 		</cfquery>
! 	<cfelseif dbProcess IS "CreateTable_Step1">
! 	<cfelse>  
! 		<cfquery name="fieldList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
! 			SHOW FIELDS FROM #url.table#;
! 		</cfquery>
! 	</cfif>
! </cflock>

  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
--- 25,38 ----
  <!--- Run dbGeneralInfo Query --->
  <cfinclude template="Query/dbGeneralInfo.cfm">
! <!--- Run any dbProcess specific Queries --->
! <cfswitch expression="#dbProcess#"> 
! 	<cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase>
! 	<cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase>
! 	<cfcase value="ShowRecords"><cfinclude template="Query/fieldList.cfm"></cfcase>
! 	<cfcase value="CreateTable_Step1"></cfcase>
! 	<cfcase value="CreateTable_Step2"></cfcase>
! 	<cfcase value="SelectRecords"></cfcase>
! 	<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! </cfswitch>

  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">