[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.1.1.1,1.2

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-serv8401

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Bug Fixed:
[ mydatabasepilot-Bugs-713679 ] White space is not trimmed from login form

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** MyDatabasePilot.cfm	23 Mar 2003 03:44:32 -0000	1.1.1.1
--- MyDatabasePilot.cfm	6 Apr 2003 04:32:36 -0000	1.2
***************
*** 1,68 ****
! <!---*******************************************************************************************
! * 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:                                                                           *
! ********************************************************************************************--->
! 
! <!---||| Set database connection variables if new one was passed to this template |||--->
! <!--- Check to see if this template was called by FORM_LogintoDB with a new dataSource --->
! <cfif IsDefined("Form.dataSource")>
! 	<!--- Initiate an Exclusive lock to ensure the integrity of session variables --->
! 	<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
! 		<!--- Overwrite the Session variables used for Database connection with New Values --->
! 		<cfset session.dataSource = #Form.dataSource#>	<!--- Data Source --->
! 		<cfset session.userName = #Form.userName#>		<!--- User Name --->		
! 		<cfset session.password = #Form.password#>		<!--- Password --->
! 	</cflock>
! </cfif>
! 
! <!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||--->
! <!--- Run dbGeneralInfo Query --->
! <cfinclude template="Query/dbGeneralInfo.cfm">
! <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
! 	<!--- Determine if template is in "Show all tables" mode or "Show a particular table" mode and run appropriate query --->
! 	<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> <!--- used when dbProcess is DeleteTable, or ShowFields, or SelectRecords---> 
! 		<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">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
! <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<h2>Current Database: <cfoutput query="dbGeneralInfo">#dbInUse#</cfoutput></h2>
! 		<!--- Execute 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="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step2">Create Table Step two</cfcase>
! 			<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! 		</cfswitch>
! 	</td>
! </tr></table>
! <cfinclude template="Include/Footer.cfm">
! </body>
  </html>
--- 1,70 ----
! <!---*******************************************************************************************
! * 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:                                                                           *
! ********************************************************************************************--->
! 
! <!---||| Set database connection variables if new one was passed to this template |||--->
! <!--- Check to see if this template was called by FORM_LogintoDB with a new dataSource --->
! <cfif IsDefined("Form.dataSource")>
! 	<!--- Initiate an Exclusive lock to ensure the integrity of session variables --->
! 	<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
! 		<!--- Using the values submitted by the login in form, --->
! 		<!--- trim leading and trailing white spaces and --->
! 		<!--- overwrite the session variables used for database connection --->
! 		<cfset session.dataSource = #Trim(Form.dataSource)#>	<!--- Data Source --->
! 		<cfset session.userName = #Trim(Form.userName)#>		<!--- User Name --->		
! 		<cfset session.password = #Trim(Form.password)#>		<!--- Password --->
! 	</cflock>
! </cfif>
! 
! <!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||--->
! <!--- Run dbGeneralInfo Query --->
! <cfinclude template="Query/dbGeneralInfo.cfm">
! <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
! 	<!--- Determine if template is in "Show all tables" mode or "Show a particular table" mode and run appropriate query --->
! 	<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> <!--- used when dbProcess is DeleteTable, or ShowFields, or SelectRecords---> 
! 		<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">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
! <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<h2>Current Database: <cfoutput query="dbGeneralInfo">#dbInUse#</cfoutput></h2>
! 		<!--- Execute 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="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step2">Create Table Step two</cfcase>
! 			<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! 		</cfswitch>
! 	</td>
! </tr></table>
! <cfinclude template="Include/Footer.cfm">
! </body>
  </html>