mydatabasepilot-cvs — CVS Commit Log

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.21,1.22

[<nan...@us...>]

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

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowFields.cfm,1.3,1.4

[<nan...@us...>]

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

Modified Files:
	ShowFields.cfm 
Log Message:
Functionality Added:
[ 744003 ] Added Form "Request Add Field(s)" to 
dbProcessBody/ShowFields.cfm 

Index: ShowFields.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowFields.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** ShowFields.cfm	25 May 2003 04:46:01 -0000	1.3
--- ShowFields.cfm	27 May 2003 03:47:20 -0000	1.4
***************
*** 7,34 ****
  ********************************************************************************************--->
  
! <!---||| Show Fields in Current Table |||--->
  <table width="100%" border="1" cellspacing="0" cellpadding="2">
! <!--- Show table name --->
! <tr><th colspan="6">Fields in Table <cfoutput>#url.table#</cfoutput></th></tr>
! <!--- Column Headers --->
! <tr>
! 	<th>Field Name</th>
! 	<th>Key</th>
! 	<th>Data Type</th>
! 	<th>Null Value Allowed</th>
! 	<th>Default Value</th>
! 	<th>Extra Properties</th>
! </tr>
! <!--- Create List of Fields --->
! <cfoutput query="fieldList">
! 	<!--- Alternate the Row Colours from class style Odd to class style Even --->
! 	<tr class="#IIF(fieldList.currentrow MOD 2, DE('Odd'), DE('Even'))#">
! 		<td>#FIELD#</td>
! 		<td><cfif KEY IS NULL OR KEY IS "">&nbsp;<cfelse>#KEY#</cfif></td>
! 		<td>#TYPE#</td>
! 		<td><cfif NULL IS "">NO<cfelse>#NULL#</cfif></td>
! 		<td><cfif DEFAULT IS NULL OR DEFAULT IS "">&nbsp;<cfelse>#DEFAULT#</cfif></td>
! 		<td><cfif EXTRA IS NULL OR EXTRA IS "">&nbsp;<cfelse>#EXTRA#</cfif></td>
  	</tr>
! </cfoutput>
! </table>
\ No newline at end of file
--- 7,72 ----
  ********************************************************************************************--->
  
! <!------------------------------------>
! <!--- Show Fields in Current Table --->
! <!------------------------------------>
  <table width="100%" border="1" cellspacing="0" cellpadding="2">
! 	<!---||| Show table name |||--->
! 	<tr><th colspan="6">Fields in Table <cfoutput>#URL.table#</cfoutput></th></tr>
! 	
! 	<!---||| Show Column Headers |||--->
! 	<tr>
! 		<th>Field Name</th>
! 		<th>Key</th>
! 		<th>Data Type</th>
! 		<th>Null Value Allowed</th>
! 		<th>Default Value</th>
! 		<th>Extra Properties</th>
  	</tr>
! 	
! 	<!---||| Show List of Fields |||--->
! 	<cfoutput query="fieldList">
! 		<!--- Alternate the Row Colours from class style Odd to class style Even --->
! 		<tr class="#IIF(fieldList.currentrow MOD 2, DE('Odd'), DE('Even'))#">
! 			<td>#fieldList.FIELD#</td>
! 			<td><cfif fieldList.KEY IS NULL OR fieldList.KEY IS "">&nbsp;<cfelse>#fieldList.KEY#</cfif></td>
! 			<td>#fieldList.TYPE#</td>
! 			<td><cfif fieldList.NULL IS "">NO<cfelse>#fieldList.NULL#</cfif></td>
! 			<td><cfif fieldList.DEFAULT IS NULL OR fieldList.DEFAULT IS "">&nbsp;<cfelse>#fieldList.DEFAULT#</cfif></td>
! 			<td><cfif fieldList.EXTRA IS NULL OR fieldList.EXTRA IS "">&nbsp;<cfelse>#fieldList.EXTRA#</cfif></td>
! 		</tr>
! 	</cfoutput>
! </table>
! 
! <!---------------------------------------->
! <!--- Show Form "Request Add Field(s)" --->
! <!---------------------------------------->
! <!---||| Initiate a Read Only lock to ensure the integrity of session variables |||--->
! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! 	<!---||| Create Form that links to AddField dbProcess |||--->
! 	<cfform action="#currentPath#?#SESSION.URLToken#&dbProcess=AddField&table=#URL.table#" method="post" name="FORM_RequestAddField" enablecab="yes" class="Fancy">
! 		<fieldset class="Fancy">
! 			<legend class="Fancy">Add New Field(s)</legend>
! 			
! 			<!---||| Allow User to Specify the Number of New Fields |||--->
! 			<label for="numberOfFields" class="Fancy">Number of New Fields:</label>
! 			<cfinput name="numberOfFields" type="text" value="1" size="2" maxlength="2" range="1,99" required="yes" message="You must enter an interger between 1 and 99 for the number of records field." validate="integer" class="Fancy" />
! 			<br />
! 			
! 			<!---||| Allow User to Specify the Location for the New Fields |||--->
! 			<label for="locationOfFields" class="Fancy">Location of New Fields:</label>
! 			<cfselect name="locationOfFields" size="1" required="yes" class="Fancy">
! 				<!--- Create options for adding the new field(s) at the beginning and at the end of the current table --->
! 				<option value="End" selected class="Fancy">At End of Table <cfoutput>#URL.table#</cfoutput></option>
! 				<option value="Beginning" class="Fancy">At Beginning of Table <cfoutput>#URL.table#</cfoutput></option>
! 				<!--- Create options for adding the new field(s) after each of the current fields --->
! 				<cfoutput query="fieldList">
! 					<option value="#fieldList.FIELD#" class="Fancy">After #fieldList.FIELD#</option>
! 				</cfoutput>
! 			</cfselect>
! 			<br />
! 			
! 			<!---||| Submit Request |||--->
! 			<input name="DefineNewFields" type="submit" value="Define New Fields">
! 		</fieldset>
! 	</cfform>
! </cflock>
\ No newline at end of file

[Mydatabasepilot-cvs] MyDatabasePilot/Styles master-test.html,1.3,1.4 master.css,1.1.1.1,1.2

[<nan...@us...>]

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

Modified Files:
	master-test.html master.css 
Log Message:
Cosmetic Change:
[ 743423 ] Added Fancy Form class to Style Sheet

Index: master-test.html
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Styles/master-test.html,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** master-test.html	30 Mar 2003 04:37:14 -0000	1.3
--- master-test.html	26 May 2003 02:44:36 -0000	1.4
***************
*** 34,38 ****
  	This is a Form<br>
  	<fieldset>
! 		<LEGEND>Personal Information</LEGEND>
  		<LABEL for="firstname">First name: </LABEL><input type="text" id="firstname" value="Jane"><BR>
  		<LABEL for="lastname">Last name: </LABEL><input type="text" id="lastname" value="Smith"><BR>
--- 34,38 ----
  	This is a Form<br>
  	<fieldset>
! 		<legend>Personal Information</legend>
  		<LABEL for="firstname">First name: </LABEL><input type="text" id="firstname" value="Jane"><BR>
  		<LABEL for="lastname">Last name: </LABEL><input type="text" id="lastname" value="Smith"><BR>
***************
*** 41,45 ****
  	</fieldset>
  	
!   	<textarea cols="30" rows="5" class="ElegantForms">TextArea</textarea><br>
  	
  	<select name="">
--- 41,45 ----
  	</fieldset>
  	
!   	<textarea cols="30" rows="5">TextArea</textarea><br>
  	
  	<select name="">
***************
*** 49,79 ****
  		<option value="4">Option Four</option>
  		<option value="5">Option Five</option>
! 	</select><br>
! 
! 	<SELECT name="ComOS">
! 		<OPTGROUP label="PortMaster 3">
! 			<OPTION label="3.7.1" value="pm3_3.7.1">PortMaster 3 with ComOS 3.7.1
! 			<OPTION label="3.7" value="pm3_3.7">PortMaster 3 with ComOS 3.7
! 			<OPTION label="3.5" value="pm3_3.5">PortMaster 3 with ComOS 3.5
! 		</OPTGROUP>
! 		<OPTGROUP label="PortMaster 2">
! 			<OPTION label="3.7" value="pm2_3.7">PortMaster 2 with ComOS 3.7
! 			<OPTION label="3.5" value="pm2_3.5">PortMaster 2 with ComOS 3.5
! 		</OPTGROUP>
! 		<OPTGROUP label="IRX">
! 			<OPTION label="3.7R" value="IRX_3.7R">IRX with ComOS 3.7R
! 			<OPTION label="3.5R" value="IRX_3.5R">IRX with ComOS 3.5R
! 		</OPTGROUP>
! 	</SELECT><br>
  
  	
  	<fieldset>
  		<legend>Special</LEGEND>
! 		<input type="checkbox" value="" class="ElegantForms">
! 		<input type="checkbox" value="" checked class="ElegantForms"><br>
  	    <LABEL for="male">Male: </LABEL><input id="male" type="radio" name="sex" value="Male" checked> Male<BR>
  	    <LABEL for="female">Female: </LABEL><INPUT id="female" type="radio" name="sex" value="Female"> Female<BR>
! 		<input type="button" value="Input Button" class="ElegantFormButton"><br>
! 		<button class="ElegantFormButton">Image Button</button><br>
  		<input type="file" name="File" accept="text/plain" >
  	</fieldset>
--- 49,78 ----
  		<option value="4">Option Four</option>
  		<option value="5">Option Five</option>
! 	</select><br />
  
+ 	<select name="MyDatabasePilot">
+ 		<optgroup label="Version 3">
+ 			<option label="3 Flash" value="3Flash">MyDatabasePilot 3 with Flash</option>
+ 			<option label="3 Java" value="3Java">MyDatabasePilot 3 with Java</option>
+ 			<option label="3 Basic" value="3Base">MyDatabasePilot 3 Basic</option>
+ 		</optgroup>
+ 		<optgroup label="Version 2">
+ 			<option label="2 Flash" value="2Flash">MyDatabasePilot 2 with Flash</option>
+ 			<option label="2 Basic" value="2Base">MyDatabasePilot 2 Basic</option>
+ 		</optgroup>
+ 		<optgroup label="Version 1">
+ 			<option label="1 Flash" value="1Flash">MyDatabasePilot 1 with Flash</option>
+ 			<option label="1 Basic" value="1Base">MyDatabasePilot 1 Basic</option>
+ 		</optgroup>
+ 	</select><br />
  	
  	<fieldset>
  		<legend>Special</LEGEND>
! 		<input type="checkbox" value="" />
! 		<input type="checkbox" value="" checked /><br />
  	    <LABEL for="male">Male: </LABEL><input id="male" type="radio" name="sex" value="Male" checked> Male<BR>
  	    <LABEL for="female">Female: </LABEL><INPUT id="female" type="radio" name="sex" value="Female"> Female<BR>
! 		<input type="button" value="Input Button"><br>
! 		<button>Image Button</button><br>
  		<input type="file" name="File" accept="text/plain" >
  	</fieldset>
***************
*** 81,90 ****
  	<fieldset>
  		<legend>Form Control</LEGEND>
! 		<input type="submit" value="Send" class="ElegantFormButton">
! 		<input type="reset" class="ElegantFormButton">
  	</fieldset>
  </FORM>
  
  
  </body>
! </html>
--- 80,146 ----
  	<fieldset>
  		<legend>Form Control</LEGEND>
! 		<input type="submit" value="Send">
! 		<input type="reset">
  	</fieldset>
  </FORM>
  
  
+ <FORM action="http://www.PoliceOrdnance.com/prog/adduser" method="post" class="Fancy">
+ 	This is a Fancy Form<br />
+ 	<fieldset class="Fancy">
+ 		<LEGEND class="Fancy">Personal Information</LEGEND>
+ 		<LABEL for="firstname" class="Fancy">First name: </LABEL><input type="text" id="firstname" value="Jane" class="Fancy"><br />
+ 		<LABEL for="lastname" class="Fancy">Last name: </LABEL><input type="text" id="lastname" value="Smith" class="Fancy"><br />
+ 		<LABEL for="email" class="Fancy">email: </LABEL><input type="text" id="email" value="ja...@ao..." class="Fancy"><br />
+ 		<LABEL for="password" class="Fancy">Password: </LABEL><input type="password" value="Password" class="Fancy">
+ 	</fieldset>
+ 	
+   	<textarea cols="30" rows="5" class="Fancy">TextArea</textarea><br>
+ 	
+ 	<select name="" class="Fancy">
+ 		<option value="1" selected class="Fancy">Option One</option>
+ 		<option value="2" class="Fancy">Option Two</option>
+ 		<option value="3" class="Fancy">Option Three</option>
+ 		<option value="4" class="Fancy">Option Four</option>
+ 		<option value="5" class="Fancy">Option Five</option>
+ 	</select><br>
+ 
+ 	<select name="ComOS" class="Fancy">
+ 		<optgroup label="Version 3" class="Fancy">
+ 			<option label="3 Flash" value="3Flash" class="Fancy">MyDatabasePilot 3 with Flash</option>
+ 			<option label="3 Java" value="3Java" class="Fancy">MyDatabasePilot 3 with Java</option>
+ 			<option label="3 Basic" value="3Base" class="Fancy">MyDatabasePilot 3 Basic</option>
+ 		</optgroup>
+ 		<optgroup label="Version 2" class="Fancy">
+ 			<option label="2 Flash" value="2Flash" class="Fancy">MyDatabasePilot 2 with Flash</option>
+ 			<option label="2 Basic" value="2Base" class="Fancy">MyDatabasePilot 2 Basic</option>
+ 		</optgroup>
+ 		<optgroup label="Version 1" class="Fancy">
+ 			<option label="1 Flash" value="1Flash" class="Fancy">MyDatabasePilot 1 with Flash</option>
+ 			<option label="1 Basic" value="1Base" class="Fancy">MyDatabasePilot 1 Basic</option>
+ 		</optgroup>
+ 	</select><br />
+ 
+ 	<fieldset class="Fancy">
+ 		<legend class="Fancy">Special</legend>
+ 		<input type="checkbox" value="" class="Fancy" />
+ 		<input type="checkbox" value="" checked class="Fancy" /><br />
+ 	    <label for="male" class="Fancy" />Male: </label>
+ 			<input id="male" type="radio" name="sex" value="Male" checked class="Fancy" /> Male<br />
+ 	    <label for="female" class="Fancy" />Female: </label>
+ 			<input id="female" type="radio" name="sex" value="Female" class="Fancy" /> Female<br />
+ 		<input type="button" value="Input Button" class="Fancy" /><br />
+ 		<button class="Fancy">Image Button</button><br />
+ 		<input type="file" name="File" accept="text/plain" class="Fancy" />
+ 	</fieldset>
+ 	
+ 	<fieldset class="Fancy">
+ 		<legend class="Fancy">Form Control</legend>
+ 		<input type="submit" value="Send" class="Fancy" />
+ 		<input type="reset" class="Fancy" />
+ 	</fieldset>
+ </form>
+ 
+ 
  </body>
! </html>
\ No newline at end of file

Index: master.css
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Styles/master.css,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** master.css	23 Mar 2003 03:44:38 -0000	1.1.1.1
--- master.css	26 May 2003 02:44:36 -0000	1.2
***************
*** 1,93 ****
! /*Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license*/
! 
! /*=== IDs ===*/
! 	/* None for now */
! 
! /*=== Default Formating ===*/
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,blockquote,q,code,pre,tt,address,noscript{font-size:14px;}
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,blockquote,q,code,pre,tt,address,noscript{color: #000000;}
! body{background:#CCCCFF; margin:0px; padding:0px;}
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,address,noscript{font-family: "Times New Roman", Times, serif;}
! code,pre,tt {font-family: courier,sans-serif}
! blockquote,q{font-family: Arial, Helvetica, sans-serif;}
! 
! /*=== Paragraph Formating ===*/
! p{text-align:justify; text-indent:30px;}
! p:first-letter{font-size:16px; font-style:oblique; font-weight:bold;}
! p.Plain, p:first-letter.Plain{text-indent: 0px;	font: normal normal 14px;}
! 
! /*=== Headings ===*/
! h1, h2, h3, h4, h5, h6{
! 	font-family: serif, Geneva, sans-serif, Arial, Helvetica;
! 	color: #330066;
! 	background-color : #9999CC;
! 	font-weight : bold;
! 	font-style : italic;
! 	padding : 3px;
! 	margin-bottom : 3px;
! 	margin-top : 3px;
! }
! h1{font-size : 26px;border : ridge;text-align: center;}
! h2{text-indent : 5px;font-size : 23px;}
! h3{text-indent : 30px;font-size : 20px;}
! h4{text-indent :55px;font-size : 18px;}
! h5{text-indent : 80px;font-size : 16px;}
! H6{text-indent : 105px;font-size : 14px;}
! 
! /*=== Links ===*/
! a{font-weight: inherit; font-size : inherit; font-family : inherit;}
! a:Link{color : #0066CC;}
! a:Visited{color : #9900CC;}
! a:Link, a:Visited{text-decoration: none;background-color : #FFFFCC;}
! a:Hover, a:Visited:Hover{color: #990000;text-decoration: underline;background-color : #FFFF99;}
! a:Active{color:#FF0000;text-decoration: underline;background-color : #FFFF99;}
! 
! /*=== Forms ===*/
!  /* This requires work and testing */
! /*form,label,input,select,optgroup,option,textarea,fieldset,legend,button{font-size: xx-small;font-family: Arial, Helvetica, sans-serif;}
! form,fieldset{color: #000000;padding : 3px 3px 3px;}
! form{border: 3px ridge;background-color: #CCCC99;margin: 15px 15px 15px 15px;}
! fieldset{margin: 5px 5px 5px 5px;}
! legend{color: #660099;font : small-caps;letter-spacing: 4px;}
! label,input,select,textarea,button{margin: 2px 2px 2px 2px;}
! label{color: #663300;}
! input,select,optgroup,option,textarea{color: #666666;}
! .ElegantFormButton{background : #CCCCFF;color : #663366;font : bolder;}*/
! 
! /*=== General Classes ===*/
! .ToDo{
! 	background : #FF9900;
! 	color : #990066;
! 	font-size : 11pt;
! }
! .Warning{
! 	background : #FF9900;
! 	color : #990066;
! 	font-size : 16pt;
! }
! 
! .Bold{font-weight:bold;}
! .BoldCenter{font-weight:bold;text-align:center;}
! .Center{text-align:center}
! .Right{text-align:right;}
! 
! /*=== Tag Specific Classes ===*/
! tr.Head{background:#9999CC;}
! tr.Odd{background:#999966;}
! tr.Even{background:#CCCC99;}
! 
! div.Code, pre.Code{
! 	text-align : left;
! 	background-color : #CCCCCC;
! 	margin : 5px 20px 5px 20px;
! 	font-family : "Courier New", Courier, monospace;
! 	padding : 5px 20px 5px 20px;
! 	font-size : 11pt;
! }
! 
! span.Code{
! 	background-color : #CCCCCC;
! 	font-family : "Courier New", Courier, monospace;
! 	font-size : 11pt;
! 	padding : 0px 2px 0px 2px;
  }
--- 1,106 ----
! /*Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license*/
! 
! /*=== IDs ===*/
! 	/* None for now */
! 
! /*=== Default Formating ===*/
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,blockquote,q,code,pre,tt,address,noscript{font-size:14px;}
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,blockquote,q,code,pre,tt,address,noscript{color: #000000;}
! body{background:#CCCCFF; margin:0px; padding:0px;}
! body,p,div,span,ul,ol,li,dl,dt,dd,td,tr,th,address,noscript{font-family: "Times New Roman", Times, serif;}
! code,pre,tt {font-family: courier,sans-serif}
! blockquote,q{font-family: Arial, Helvetica, sans-serif;}
! 
! /*=== Paragraph Formating ===*/
! p{text-align:justify; text-indent:30px;}
! p:first-letter{font-size:16px; font-style:oblique; font-weight:bold;}
! p.Plain, p:first-letter.Plain{text-indent: 0px;	font: normal normal 14px;}
! 
! /*=== Headings ===*/
! h1, h2, h3, h4, h5, h6{
! 	font-family: serif, Geneva, sans-serif, Arial, Helvetica;
! 	color: #330066;
! 	background-color : #9999CC;
! 	font-weight : bold;
! 	font-style : italic;
! 	padding : 3px;
! 	margin-bottom : 3px;
! 	margin-top : 3px;
! }
! h1{font-size : 26px;border : ridge;text-align: center;}
! h2{text-indent : 5px;font-size : 23px;}
! h3{text-indent : 30px;font-size : 20px;}
! h4{text-indent :55px;font-size : 18px;}
! h5{text-indent : 80px;font-size : 16px;}
! H6{text-indent : 105px;font-size : 14px;}
! 
! /*=== Links ===*/
! a{font-weight: inherit; font-size : inherit; font-family : inherit;}
! a:Link{color : #0066CC;}
! a:Visited{color : #9900CC;}
! a:Link, a:Visited{text-decoration: none;background-color : #FFFFCC;}
! a:Hover, a:Visited:Hover{color: #990000;text-decoration: underline;background-color : #FFFF99;}
! a:Active{color:#FF0000;text-decoration: underline;background-color : #FFFF99;}
! 
! /*=== Forms ===*/
! form,label,input,select,optgroup,option,textarea,fieldset,legend,button{
! 	font-size : 11pt;
! 	font-family : Arial, Helvetica, sans-serif;
! }
! 
! /*=== General Classes ===*/
! .ToDo{
! 	background : #FF9900;
! 	color : #990066;
! 	font-size : 11pt;
! }
! .Warning{
! 	background : #FF9900;
! 	color : #990066;
! 	font-size : 16pt;
! }
! 
! .Bold{font-weight:bold;}
! .BoldCenter{font-weight:bold;text-align:center;}
! .Center{text-align:center}
! .Right{text-align:right;}
! 
! /*=== Tag Specific Classes ===*/
! tr.Head{background:#9999CC;}
! tr.Odd{background:#999966;}
! tr.Even{background:#CCCC99;}
! 
! div.Code, pre.Code{
! 	text-align : left;
! 	background-color : #CCCCCC;
! 	margin : 5px 20px 5px 20px;
! 	font-family : "Courier New", Courier, monospace;
! 	padding : 5px 20px 5px 20px;
! 	font-size : 11pt;
! }
! 
! span.Code{
! 	background-color : #CCCCCC;
! 	font-family : "Courier New", Courier, monospace;
! 	font-size : 11pt;
! 	padding : 0px 2px 0px 2px;
! }
! 
! /* Fancy Form */
! form.Fancy,fieldset.Fancy{
! 	color : #000000;
! 	padding : 3px 3px 3px;
! 	border : 3px ridge;
! }
! form.Fancy{
! 	background-color : #CCCC99;
! 	margin: 15px 15px 15px 15px;
! }
! fieldset.Fancy{margin: 5px 5px 5px 5px;}
! legend.Fancy{color: #660099;font : small-caps;letter-spacing: 4px;}
! label.Fancy,input.Fancy,select.Fancy,textarea.Fancy,button.Fancy,legend.Fancy{margin: 2px 2px 2px 2px;}
! label.Fancy{color: #663300;}
! input.Fancy,select.Fancy,optgroup.Fancy,option.Fancy,textarea.Fancy,button.Fancy{
! 	background-color : #FFFFCC;
! 	color: #666666;
  }

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.20,1.21

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Functionality Added:
[ 743229 ] Added file dbProcessBody/AddField.cfm and include it in 
MyDatabasePilot.cfm

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** MyDatabasePilot.cfm	24 May 2003 18:49:18 -0000	1.20
--- MyDatabasePilot.cfm	25 May 2003 16:18:59 -0000	1.21
***************
*** 49,53 ****
  	<cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase>
  	<cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm"></cfcase>
! 	<cfcase value="AddField">Add Field</cfcase>
  	<cfcase value="AlterField">Alter Field</cfcase>
  	<cfcase value="DropField">Drop Field</cfcase>
--- 49,53 ----
  	<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>

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,NONE,1.1

[<nan...@us...>]

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

Added Files:
	AddField.cfm 
Log Message:
Functionality Added:
[ 743229 ] Added file dbProcessBody/AddField.cfm and include it in 
MyDatabasePilot.cfm

--- NEW FILE: AddField.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         dbProcessBody/AddField.cfm                                                 *
* Purpose:          Displays the Body Content for the AddField Database Process                *
* Requiremets:      -fieldList Query must be run on same page prior to including this template *
*                   -FORM.table (table name) must have been passed from calling template       *
********************************************************************************************--->

Add Field 

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowFields.cfm,1.2,1.3

[<nan...@us...>]

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

Modified Files:
	ShowFields.cfm 
Log Message:
Cosmetic Change:
[ 743013 ] Alternate the Row Colours in Show Fields

Index: ShowFields.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowFields.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ShowFields.cfm	13 Apr 2003 06:35:24 -0000	1.2
--- ShowFields.cfm	25 May 2003 04:46:01 -0000	1.3
***************
*** 22,26 ****
  <!--- Create List of Fields --->
  <cfoutput query="fieldList">
! 	<tr>
  		<td>#FIELD#</td>
  		<td><cfif KEY IS NULL OR KEY IS "">&nbsp;<cfelse>#KEY#</cfif></td>
--- 22,27 ----
  <!--- Create List of Fields --->
  <cfoutput query="fieldList">
! 	<!--- Alternate the Row Colours from class style Odd to class style Even --->
! 	<tr class="#IIF(fieldList.currentrow MOD 2, DE('Odd'), DE('Even'))#">
  		<td>#FIELD#</td>
  		<td><cfif KEY IS NULL OR KEY IS "">&nbsp;<cfelse>#KEY#</cfif></td>

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowRecords.cfm,1.4,1.5

[<nan...@us...>]

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

Modified Files:
	ShowRecords.cfm 
Log Message:
Cosmetic Change:
[ 743007 ] Alternate the Row Colours in Show Records

Index: ShowRecords.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowRecords.cfm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** ShowRecords.cfm	9 May 2003 04:08:02 -0000	1.4
--- ShowRecords.cfm	25 May 2003 04:30:43 -0000	1.5
***************
*** 77,93 ****
  <!--- Loop through records using Index Loop so we can reference the recordnumber in a dynamic variable --->
  <cfloop from="1" to="#selectedData.RecordCount#" index="i">
! <tr>
! 	<td valign="top">Update/Delete Record</td>
! 	<!--- Loop through fields --->
! 	<cfloop query="fieldList">
! 		<!--- Output the value of a dynamically created variable which references the current field of the current record --->
! 		<!--- Use the Evaluate function to get the value of the Dynamic Variable --->
! 		<!--- The Dynamic variable is queryName.columName[recordNumber] --->
! 		<!--- Where queryName is "selectedData" --->
! 		<!--- columName is the value of fieldList.FIELD --->
! 		<!--- recordNumber is "i" --->
! 		<td valign="top"><cfoutput>#Evaluate("selectedData." & fieldList.FIELD & "[i]")#</cfoutput></td>
! 	</cfloop>
! </tr>
  </cfloop>
  </table>
--- 77,96 ----
  <!--- Loop through records using Index Loop so we can reference the recordnumber in a dynamic variable --->
  <cfloop from="1" to="#selectedData.RecordCount#" index="i">
! 	<cfoutput>
! 		<!--- Alternate the Row Colours from class style Odd to class style Even --->
! 		<tr class="#IIF(i MOD 2, DE('Odd'), DE('Even'))#">
! 			<td valign="top">Update/Delete Record</td>
! 			<!--- Loop through fields --->
! 			<cfloop query="fieldList">
! 				<!--- Output the value of a dynamically created variable which references the current field of the current record --->
! 				<!--- Use the Evaluate function to get the value of the Dynamic Variable --->
! 				<!--- The Dynamic variable is queryName.columName[recordNumber] --->
! 				<!--- Where queryName is "selectedData" --->
! 				<!--- columName is the value of fieldList.FIELD --->
! 				<!--- recordNumber is "i" --->
! 				<td valign="top">#Evaluate("selectedData." & fieldList.FIELD & "[i]")#</td>
! 			</cfloop>
! 		</tr>
! 	</cfoutput>
  </cfloop>
  </table>

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowTables.cfm,1.5,1.6

[<nan...@us...>]

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

Modified Files:
	ShowTables.cfm 
Log Message:
Cosmetic Change:
[ 743005 ]  Alternate the Row Colours in Show Tables

Index: ShowTables.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** ShowTables.cfm	24 Apr 2003 03:07:10 -0000	1.5
--- ShowTables.cfm	25 May 2003 04:06:13 -0000	1.6
***************
*** 7,11 ****
  
  <!---||| Show Tables in Current Database |||--->
! <table width="100%" border="1" cellspacing="0" cellpadding="2">
  <tr>
  	<th>Table Name</th>
--- 7,11 ----
  
  <!---||| Show Tables in Current Database |||--->
! <table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr>
  	<th>Table Name</th>
***************
*** 16,20 ****
  	<!--- 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
--- 16,22 ----
  	<!--- Create List of Tables --->
  	<cfoutput query="tableList">
! 		<!--- Alternate the Row Colours from class style Odd to class style Even --->
! 		<tr class="#IIF(tableList.currentrow MOD 2, DE('Odd'), DE('Even'))#">
! 			<!--- 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

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.19,1.20

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 742818 ] Moved Initialization Code for dbProcess ShowRecords 
to include file dbProcessInit/ShowRecords.cfm

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** MyDatabasePilot.cfm	24 May 2003 17:12:18 -0000	1.19
--- MyDatabasePilot.cfm	24 May 2003 18:49:18 -0000	1.20
***************
*** 18,103 ****
  	<cfcase value="ShowTables"><cfinclude template="dbProcessInit/ShowTables.cfm"></cfcase>
  	<cfcase value="ShowFields"><cfinclude template="dbProcessInit/ShowFields.cfm"></cfcase>
! 	
! 	<!---||| If ShowRecords ... |||--->
! 	<cfcase value="ShowRecords">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get Record Count --->
! 			<cfmodule template="Query/recordCount.cfm"
! 				queryName="recordCount"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 
! 		<!---||| Determine if any of the navigation buttons were used to request a set of records and set set limit variables accordingly |||--->
! 		<!--- If First button was clicked ... --->
! 		<cfif IsDefined("FORM.First")>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Previous button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Previous")>
! 			<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
! 			<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
! 			<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
! 			<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Next button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Next")>
! 			<!--- Set initial record limit to one more than the last record used on the previous request --->
! 			<cfset initialRecord = FORM.lastRecord + 1>
! 			<!--- Make sure that initial record is no greater than the record count minus number of records --->
! 			<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
! 				<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			</cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Last button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Last")>
! 			<!--- Set initial record limit to the difference between available records and requested number of records --->
! 			<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
! 		<cfelse>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
! 			<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
! 				<!--- Set total number of records limit to the defaultMaxRows client setting --->
! 				<cfset numberOfRecords = client.defaultMaxRows>
! 			</cflock>
! 		</cfif>
! 		
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 			<!--- Get Requested Records --->
! 			<cfmodule template="Query/SELECT.cfm"
! 				queryName="selectedData"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				tables="#URL.table#"
! 				initialRecord="#initialRecord#"
! 				numberOfRecords="#numberOfRecords#">
! 			</cfmodule>
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If AddField ... |||--->
  	<cfcase value="AddField"></cfcase>
- 	
- 	<!---||| If AlterField ... |||--->
  	<cfcase value="AlterField"></cfcase>
  	<cfcase value="DropField"></cfcase>
--- 18,23 ----
  	<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>

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessInit ShowRecords.cfm,NONE,1.1

[<nan...@us...>]

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

Added Files:
	ShowRecords.cfm 
Log Message:
Internal Structure Changed:
[ 742818 ] Moved Initialization Code for dbProcess ShowRecords 
to include file dbProcessInit/ShowRecords.cfm

--- NEW FILE: ShowRecords.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         dbProcessInit/ShowRecords.cfm                                              *
* Purpose:          Initialize ShowRecords Database Process                                    *
********************************************************************************************--->

<!---||| Get Record Count |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
	<!--- Invoke recordCount Custom Tag via CFModule --->
	<cfmodule template="../Query/recordCount.cfm"
		queryName="recordCount"
		datasource="#SESSION.dataSource#"
		username="#SESSION.userName#"
		password="#SESSION.password#"
		table="#URL.table#">
</cflock>

<!---||| Determine if any of the navigation buttons were used to request a set of records and set limit variables accordingly |||--->
<!--- If First button was clicked ... --->
<cfif IsDefined("FORM.First")>
	<!--- Set initial record limit to Zero --->
	<cfset initialRecord = 0>
	<!--- Set total number of records limit to the value passed by the form --->
	<cfset numberOfRecords = FORM.numberOfRecords>
<!--- If Previous button was clicked ... --->
<cfelseif IsDefined("FORM.Previous")>
	<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
	<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
	<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
	<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
	<!--- Set total number of records limit to the value passed by the form --->
	<cfset numberOfRecords = FORM.numberOfRecords>
<!--- If Next button was clicked ... --->
<cfelseif IsDefined("FORM.Next")>
	<!--- Set initial record limit to one more than the last record used on the previous request --->
	<cfset initialRecord = FORM.lastRecord + 1>
	<!--- Make sure that initial record is no greater than the record count minus number of records --->
	<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
		<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
	</cfif>
	<!--- Set total number of records limit to the value passed by the form --->
	<cfset numberOfRecords = FORM.numberOfRecords>
<!--- If Last button was clicked ... --->
<cfelseif IsDefined("FORM.Last")>
	<!--- Set initial record limit to the difference between available records and requested number of records --->
	<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
	<!--- Set total number of records limit to the value passed by the form --->
	<cfset numberOfRecords = FORM.numberOfRecords>
<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
<cfelse>
	<!--- Set initial record limit to Zero --->
	<cfset initialRecord = 0>
	<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
	<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
		<!--- Set total number of records limit to the defaultMaxRows client setting --->
		<cfset numberOfRecords = client.defaultMaxRows>
	</cflock>
</cfif>
		
<!---||| Get List of Field Names, and Requested Records |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
	<!--- Invoke fieldList Custom Tag via CFModule --->
	<cfmodule template="../Query/fieldList.cfm"
		queryName="fieldList"
		datasource="#SESSION.dataSource#"
		username="#SESSION.userName#"
		password="#SESSION.password#"
		table="#URL.table#">
	<!--- Invoke SELECT Custom Tag via CFModule --->
	<cfmodule template="../Query/SELECT.cfm"
		queryName="selectedData"
		datasource="#SESSION.dataSource#"
		username="#SESSION.userName#"
		password="#SESSION.password#"
		tables="#URL.table#"
		initialRecord="#initialRecord#"
		numberOfRecords="#numberOfRecords#">
	</cfmodule>
</cflock>

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.18,1.19

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 742784 ] Moved Initialization Code for dbProcess ShowFields to 
include file dbProcessInit/ShowFields.cfm

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** MyDatabasePilot.cfm	23 May 2003 02:28:49 -0000	1.18
--- MyDatabasePilot.cfm	24 May 2003 17:12:18 -0000	1.19
***************
*** 14,35 ****
  <!--- Run Requested Database Command or Query --->
  <!----------------------------------------------->
! <!---||| Which dbProcess was requested? |||--->
  <cfswitch expression="#dbProcess#">
- 	<!---||| If ShowTables ... |||--->
  	<cfcase value="ShowTables"><cfinclude template="dbProcessInit/ShowTables.cfm"></cfcase>
! 	
! 	<!---||| If ShowFields ... |||--->
! 	<cfcase value="ShowFields">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names and Their Properties --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 	</cfcase>
  	
  	<!---||| If ShowRecords ... |||--->
--- 14,21 ----
  <!--- 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>
  	
  	<!---||| If ShowRecords ... |||--->

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessInit ShowFields.cfm,NONE,1.1

[<nan...@us...>]

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

Added Files:
	ShowFields.cfm 
Log Message:
Internal Structure Changed:
[ 742784 ] Moved Initialization Code for dbProcess ShowFields to 
include file dbProcessInit/ShowFields.cfm

--- NEW FILE: ShowFields.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         dbProcessInit/ShowFields.cfm                                               *
* Purpose:          Initialize ShowFields Database Process                                     *
********************************************************************************************--->

<!---||| Get List of Field Names and Their Properties |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
	<!--- Invoke fieldList Custom Tag via CFModule --->
	<cfmodule template="../Query/fieldList.cfm"
		queryName="fieldList"
		datasource="#SESSION.dataSource#"
		username="#SESSION.userName#"
		password="#SESSION.password#"
		table="#URL.table#">
</cflock>

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.15,1.16

[<nan...@us...>]

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

Modified Files:
	Application.cfm 
Log Message:
Functionality Added:
[ 742144 ] Added Application var isMX_Compatible
Contributed by: Graham Lloyd

Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** Application.cfm	23 May 2003 01:28:23 -0000	1.15
--- Application.cfm	23 May 2003 04:11:19 -0000	1.16
***************
*** 11,15 ****
  <!--- and enable client variables in the form of cookies --->
  <!---------------------------------------------------------->
! <cfapplication name="MyDatabasePilot-0.7.1.a" applicationtimeout="#CreateTimeSpan(2,0,0,0)#"
  	clientmanagement="yes" setclientcookies="yes" setdomaincookies="no"
  	sessionmanagement="yes" sessiontimeout="#CreateTimeSpan(0,0,15,0)#">
--- 11,15 ----
  <!--- and enable client variables in the form of cookies --->
  <!---------------------------------------------------------->
! <cfapplication name="MyDatabasePilot-0.7.2.a" applicationtimeout="#CreateTimeSpan(2,0,0,0)#"
  	clientmanagement="yes" setclientcookies="yes" setdomaincookies="no"
  	sessionmanagement="yes" sessiontimeout="#CreateTimeSpan(0,0,15,0)#">
***************
*** 40,46 ****
  	<cfif NOT IsDefined("APPLICATION.name")><cfset application.name = "MyDatabase Pilot"></cfif>
  	<!--- Ensure Application Version has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.version")><cfset application.version = "v0.7.1(Alpha)"></cfif>
  	<!--- Ensure Application Release Date has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.releaseDate")><cfset application.releaseDate = "9 May 2003"></cfif>
  </cflock>
  
--- 40,59 ----
  	<cfif NOT IsDefined("APPLICATION.name")><cfset application.name = "MyDatabase Pilot"></cfif>
  	<!--- Ensure Application Version has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.version")><cfset application.version = "v0.7.2(Alpha)"></cfif>
  	<!--- Ensure Application Release Date has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.releaseDate")><cfset application.releaseDate = "1 Jun 2003"></cfif>
! 	<!--- Initiate a Read Only lock to ensure the integrity of SERVER variables --->
! 	<cflock timeout = "10" throwontimeout="no" type = "readonly" scope = "SERVER">
! 		<cfscript>
! 			// Ensure isMX_Compatible is set, this is used for MX specific coding such as CFCs
! 			if(NOT IsDefined("APPLICATION.isMX_Compatible")){
! 				if(Left(SERVER.ColdFusion.ProductVersion,1) GTE 6){ // If the product version is 6 or higher ...
! 					APPLICATION.isMX_Compatible = TRUE;             // then CFServer is MX compatible.
! 				}else{                                              // Otherwise,
! 					APPLICATION.isMX_Compatible = FALSE;            // CFServer is not MX compatible.
! 				}
! 			}
! 		</cfscript>
! 	</cflock>
  </cflock>
  

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.17,1.18

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 742122 ] Moved Initialization Code for dbProcess ShowTables to 
include file dbProcessInit/ShowTables.cfm 

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** MyDatabasePilot.cfm	22 May 2003 01:49:33 -0000	1.17
--- MyDatabasePilot.cfm	23 May 2003 02:28:49 -0000	1.18
***************
*** 1,194 ****
! <!---*******************************************************************************************
! * 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         *
! ********************************************************************************************--->
! 
! <!------------------------------------------------------------------------------>
! <!--- Process User Request Input Variables and Initialize Internal Variables --->
! <!------------------------------------------------------------------------------>
! <!---||| Reset session variables if new database was requested |||--->
! <!--- 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 --->
! 		<!--- Set the loggedIn Flag to True --->
! 		<cfset SESSION.loggedIn = 1>
! 		<!--- Get Database Name --->
! 		<cfmodule template="Query/thisDatabaseName.cfm"
! 			queryName="thisDatabaseName"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		<!--- Overwrite dbName Variable --->
! 		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
! 	</cflock>
! </cfif>
! 
! <!----------------------------------------------->
! <!--- Run Requested Database Command or Query --->
! <!----------------------------------------------->
! <!--- Which dbProcess was requested? --->
! <cfswitch expression="#dbProcess#">
! <!---||| If ShowTables ... |||--->
! <cfcase value="ShowTables">
! 	<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 	<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 		<!--- Get List of Table Names --->
! 		<cfmodule template="Query/tableList.cfm"
! 			queryName="tableList"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowFields ... |||--->
! 	<cfcase value="ShowFields">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names and Their Properties --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowRecords ... |||--->
! 	<cfcase value="ShowRecords">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get Record Count --->
! 			<cfmodule template="Query/recordCount.cfm"
! 				queryName="recordCount"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 
! 		<!---||| Determine if any of the navigation buttons were used to request a set of records and set set limit variables accordingly |||--->
! 		<!--- If First button was clicked ... --->
! 		<cfif IsDefined("FORM.First")>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Previous button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Previous")>
! 			<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
! 			<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
! 			<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
! 			<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Next button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Next")>
! 			<!--- Set initial record limit to one more than the last record used on the previous request --->
! 			<cfset initialRecord = FORM.lastRecord + 1>
! 			<!--- Make sure that initial record is no greater than the record count minus number of records --->
! 			<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
! 				<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			</cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Last button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Last")>
! 			<!--- Set initial record limit to the difference between available records and requested number of records --->
! 			<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
! 		<cfelse>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
! 			<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
! 				<!--- Set total number of records limit to the defaultMaxRows client setting --->
! 				<cfset numberOfRecords = client.defaultMaxRows>
! 			</cflock>
! 		</cfif>
! 		
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 			<!--- Get Requested Records --->
! 			<cfmodule template="Query/SELECT.cfm"
! 				queryName="selectedData"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				tables="#URL.table#"
! 				initialRecord="#initialRecord#"
! 				numberOfRecords="#numberOfRecords#">
! 			</cfmodule>
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If AddField ... |||--->
! 	<cfcase value="AddField"></cfcase>
! 	
! 	<!---||| If AlterField ... |||--->
! 	<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">Add Field</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">
--- 1,160 ----
! <!---*******************************************************************************************
! * 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? |||--->
! <cfswitch expression="#dbProcess#">
! 	<!---||| If ShowTables ... |||--->
! 	<cfcase value="ShowTables"><cfinclude template="dbProcessInit/ShowTables.cfm"></cfcase>
! 	
! 	<!---||| If ShowFields ... |||--->
! 	<cfcase value="ShowFields">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names and Their Properties --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowRecords ... |||--->
! 	<cfcase value="ShowRecords">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get Record Count --->
! 			<cfmodule template="Query/recordCount.cfm"
! 				queryName="recordCount"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 
! 		<!---||| Determine if any of the navigation buttons were used to request a set of records and set set limit variables accordingly |||--->
! 		<!--- If First button was clicked ... --->
! 		<cfif IsDefined("FORM.First")>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Previous button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Previous")>
! 			<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
! 			<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
! 			<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
! 			<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Next button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Next")>
! 			<!--- Set initial record limit to one more than the last record used on the previous request --->
! 			<cfset initialRecord = FORM.lastRecord + 1>
! 			<!--- Make sure that initial record is no greater than the record count minus number of records --->
! 			<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
! 				<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			</cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Last button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Last")>
! 			<!--- Set initial record limit to the difference between available records and requested number of records --->
! 			<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
! 		<cfelse>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
! 			<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
! 				<!--- Set total number of records limit to the defaultMaxRows client setting --->
! 				<cfset numberOfRecords = client.defaultMaxRows>
! 			</cflock>
! 		</cfif>
! 		
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 			<!--- Get Requested Records --->
! 			<cfmodule template="Query/SELECT.cfm"
! 				queryName="selectedData"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				tables="#URL.table#"
! 				initialRecord="#initialRecord#"
! 				numberOfRecords="#numberOfRecords#">
! 			</cfmodule>
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If AddField ... |||--->
! 	<cfcase value="AddField"></cfcase>
! 	
! 	<!---||| If AlterField ... |||--->
! 	<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">Add Field</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">

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessInit ShowTables.cfm,NONE,1.1

[<nan...@us...>]

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

Added Files:
	ShowTables.cfm 
Log Message:
Internal Structure Changed:
[ 742122 ] Moved Initialization Code for dbProcess ShowTables to 
include file dbProcessInit/ShowTables.cfm 

--- NEW FILE: ShowTables.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         dbProcessInit/ShowTables.cfm                                               *
* Purpose:          Initialize ShowTables Database Process                                     *
********************************************************************************************--->

<!---||| Reset session variables if new database was requested |||--->
<!--- 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 --->
		<!--- Set the loggedIn Flag to True --->
		<cfset SESSION.loggedIn = 1>
		<!--- Get Database Name --->
		<cfmodule template="../Query/thisDatabaseName.cfm"
			queryName="thisDatabaseName"
			datasource="#SESSION.dataSource#"
			username="#SESSION.userName#"
			password="#SESSION.password#">
		<!--- Overwrite dbName Variable --->
		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
	</cflock>
</cfif>

<!---||| Get List of Table Names |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
	<!--- Invoke tableList Custom Tag via CFModule --->
	<cfmodule template="../Query/tableList.cfm"
		queryName="tableList"
		datasource="#SESSION.dataSource#"
		username="#SESSION.userName#"
		password="#SESSION.password#">
</cflock>

[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessInit - New directory

[<nan...@us...>]

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

Log Message:
Directory /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessInit added to the repository

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.14,1.15

[<nan...@us...>]

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

Modified Files:
	Application.cfm 
Log Message:
Functionality Added:
[ 742098 ] Added local var currentDir in Application.cfm

Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** Application.cfm	20 May 2003 04:22:09 -0000	1.14
--- Application.cfm	23 May 2003 01:28:23 -0000	1.15
***************
*** 113,116 ****
--- 113,119 ----
  <cfset mainpage = "MyDatabasePilot.cfm">
  <cfset currentPath = "#CGI.path_info#">
+ <!--- Set currentDir by Striping the currentPath string variable of the first occurance of the following:
+ One or more alpha numeric charachters or uncerscore followed by .cfm or .CFM --->
+ <cfset currentDir = REReplace(currentPath, "[[:alnum:]_]+(.cfm|.CFM)", "", "ONE")>
  <cfset currentQueryString = "#CGI.query_string#">
  <cfset currentPage = "#currentPath#?#currentQueryString#">

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.16,1.17

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 741461 ] Updated <CFSWITCH> statement in MyDatabasePilot.cfm
to reflect the current development plan 

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** MyDatabasePilot.cfm	20 May 2003 04:22:10 -0000	1.16
--- MyDatabasePilot.cfm	22 May 2003 01:49:33 -0000	1.17
***************
*** 1,175 ****
! <!---*******************************************************************************************
! * 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         *
! ********************************************************************************************--->
! 
! <!------------------------------------------------------------------------------>
! <!--- Process User Request Input Variables and Initialize Internal Variables --->
! <!------------------------------------------------------------------------------>
! <!---||| Reset session variables if new database was requested |||--->
! <!--- 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 --->
! 		<!--- Set the loggedIn Flag to True --->
! 		<cfset SESSION.loggedIn = 1>
! 		<!--- Get Database Name --->
! 		<cfmodule template="Query/thisDatabaseName.cfm"
! 			queryName="thisDatabaseName"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		<!--- Overwrite dbName Variable --->
! 		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
! 	</cflock>
! </cfif>
! 
! <!----------------------------------------------->
! <!--- Run Requested Database Command or Query --->
! <!----------------------------------------------->
! <!--- Which dbProcess was requested? --->
! <cfswitch expression="#dbProcess#">
! <!---||| If ShowTables ... |||--->
! <cfcase value="ShowTables">
! 	<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 	<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 		<!--- Get List of Table Names --->
! 		<cfmodule template="Query/tableList.cfm"
! 			queryName="tableList"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowFields ... |||--->
! 	<cfcase value="ShowFields">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names and Their Properties --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowRecords ... |||--->
! 	<cfcase value="ShowRecords">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get Record Count --->
! 			<cfmodule template="Query/recordCount.cfm"
! 				queryName="recordCount"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 
! 		<!---||| Determine if any of the navigation buttons were used to request a set of records and set set limit variables accordingly |||--->
! 		<!--- If First button was clicked ... --->
! 		<cfif IsDefined("FORM.First")>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Previous button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Previous")>
! 			<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
! 			<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
! 			<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
! 			<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Next button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Next")>
! 			<!--- Set initial record limit to one more than the last record used on the previous request --->
! 			<cfset initialRecord = FORM.lastRecord + 1>
! 			<!--- Make sure that initial record is no greater than the record count minus number of records --->
! 			<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
! 				<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			</cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Last button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Last")>
! 			<!--- Set initial record limit to the difference between available records and requested number of records --->
! 			<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
! 		<cfelse>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
! 			<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
! 				<!--- Set total number of records limit to the defaultMaxRows client setting --->
! 				<cfset numberOfRecords = client.defaultMaxRows>
! 			</cflock>
! 		</cfif>
! 		
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 			<!--- Get Requested Records --->
! 			<cfmodule template="Query/SELECT.cfm"
! 				queryName="selectedData"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				tables="#URL.table#"
! 				initialRecord="#initialRecord#"
! 				numberOfRecords="#numberOfRecords#">
! 			</cfmodule>
! 		</cflock>
! 	</cfcase>
! 	<cfcase value="CreateTable_Step1"></cfcase>
! 	<cfcase value="CreateTable_Step2"></cfcase>
! 	<cfcase value="SelectRecords"></cfcase>
! 	<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! </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="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase>
! 	<cfcase value="CreateTable_Step2">Create Table Step two</cfcase>
! 	<cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase>
! 	<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! </cfswitch>
! 
! <!---||| Include Footer |||--->
  <cfinclude template="Include/Footer.cfm">
--- 1,194 ----
! <!---*******************************************************************************************
! * 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         *
! ********************************************************************************************--->
! 
! <!------------------------------------------------------------------------------>
! <!--- Process User Request Input Variables and Initialize Internal Variables --->
! <!------------------------------------------------------------------------------>
! <!---||| Reset session variables if new database was requested |||--->
! <!--- 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 --->
! 		<!--- Set the loggedIn Flag to True --->
! 		<cfset SESSION.loggedIn = 1>
! 		<!--- Get Database Name --->
! 		<cfmodule template="Query/thisDatabaseName.cfm"
! 			queryName="thisDatabaseName"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		<!--- Overwrite dbName Variable --->
! 		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
! 	</cflock>
! </cfif>
! 
! <!----------------------------------------------->
! <!--- Run Requested Database Command or Query --->
! <!----------------------------------------------->
! <!--- Which dbProcess was requested? --->
! <cfswitch expression="#dbProcess#">
! <!---||| If ShowTables ... |||--->
! <cfcase value="ShowTables">
! 	<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 	<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 		<!--- Get List of Table Names --->
! 		<cfmodule template="Query/tableList.cfm"
! 			queryName="tableList"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowFields ... |||--->
! 	<cfcase value="ShowFields">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names and Their Properties --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If ShowRecords ... |||--->
! 	<cfcase value="ShowRecords">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get Record Count --->
! 			<cfmodule template="Query/recordCount.cfm"
! 				queryName="recordCount"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 		</cflock>
! 
! 		<!---||| Determine if any of the navigation buttons were used to request a set of records and set set limit variables accordingly |||--->
! 		<!--- If First button was clicked ... --->
! 		<cfif IsDefined("FORM.First")>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Previous button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Previous")>
! 			<!--- Set initial record limit to the difference of the first record used on the previous request and number of new records requested --->
! 			<cfset initialRecord = FORM.firstRecord - FORM.numberOfRecords>
! 			<!--- Make sure that initial record is not a negative number, the first record in MySQL is always 0 --->
! 			<cfif initialRecord LT 0><cfset initialRecord = 0></cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Next button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Next")>
! 			<!--- Set initial record limit to one more than the last record used on the previous request --->
! 			<cfset initialRecord = FORM.lastRecord + 1>
! 			<!--- Make sure that initial record is no greater than the record count minus number of records --->
! 			<cfif initialRecord GT recordCount.numOfRows - FORM.numberOfRecords>
! 				<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			</cfif>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- If Last button was clicked ... --->
! 		<cfelseif IsDefined("FORM.Last")>
! 			<!--- Set initial record limit to the difference between available records and requested number of records --->
! 			<cfset initialRecord = recordCount.numOfRows - FORM.numberOfRecords>
! 			<!--- Set total number of records limit to the value passed by the form --->
! 			<cfset numberOfRecords = FORM.numberOfRecords>
! 		<!--- Otherwise if none of the navigation buttons were clicked than this must be the first requeste for a set of reccords in this table ... --->
! 		<cfelse>
! 			<!--- Set initial record limit to Zero --->
! 			<cfset initialRecord = 0>
! 			<!--- Initiate a readonly lock to ensure the integrity of default client settings --->
! 			<cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "readonly">
! 				<!--- Set total number of records limit to the defaultMaxRows client setting --->
! 				<cfset numberOfRecords = client.defaultMaxRows>
! 			</cflock>
! 		</cfif>
! 		
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Field Names --->
! 			<cfmodule template="Query/fieldList.cfm"
! 				queryName="fieldList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				table="#URL.table#">
! 			<!--- Get Requested Records --->
! 			<cfmodule template="Query/SELECT.cfm"
! 				queryName="selectedData"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#"
! 				tables="#URL.table#"
! 				initialRecord="#initialRecord#"
! 				numberOfRecords="#numberOfRecords#">
! 			</cfmodule>
! 		</cflock>
! 	</cfcase>
! 	
! 	<!---||| If AddField ... |||--->
! 	<cfcase value="AddField"></cfcase>
! 	
! 	<!---||| If AlterField ... |||--->
! 	<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">Add Field</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">

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.13,1.14 MyDatabasePilot.cfm,1.15,1.16

[<nan...@us...>]

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

Modified Files:
	Application.cfm MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 739645 ] Move thisDatabaseName.cfm to Query Directory
Updated calls in MyDatabasePilot.cfm and Application.cfm

Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** Application.cfm	18 May 2003 04:46:12 -0000	1.13
--- Application.cfm	20 May 2003 04:22:09 -0000	1.14
***************
*** 98,102 ****
  	<cfif NOT IsDefined("SESSION.dbName") AND SESSION.loggedIn IS TRUE>
  		<!--- Get Database Name --->
! 		<cfmodule template="Query/LockRequired/thisDatabaseName.cfm"
  			queryName="thisDatabaseName"
  			datasource="#SESSION.dataSource#"
--- 98,102 ----
  	<cfif NOT IsDefined("SESSION.dbName") AND SESSION.loggedIn IS TRUE>
  		<!--- Get Database Name --->
! 		<cfmodule template="Query/thisDatabaseName.cfm"
  			queryName="thisDatabaseName"
  			datasource="#SESSION.dataSource#"

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** MyDatabasePilot.cfm	20 May 2003 03:29:46 -0000	1.15
--- MyDatabasePilot.cfm	20 May 2003 04:22:10 -0000	1.16
***************
*** 25,29 ****
  		<cfset SESSION.loggedIn = 1>
  		<!--- Get Database Name --->
! 		<cfmodule template="Query/LockRequired/thisDatabaseName.cfm"
  			queryName="thisDatabaseName"
  			datasource="#SESSION.dataSource#"
--- 25,29 ----
  		<cfset SESSION.loggedIn = 1>
  		<!--- Get Database Name --->
! 		<cfmodule template="Query/thisDatabaseName.cfm"
  			queryName="thisDatabaseName"
  			datasource="#SESSION.dataSource#"

[Mydatabasepilot-cvs] MyDatabasePilot/Query thisDatabaseName.cfm,1.2,1.3

[<nan...@us...>]

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

Modified Files:
	thisDatabaseName.cfm 
Log Message:
Internal Structure Changed:
[ 739645 ] Move thisDatabaseName.cfm to Query Directory
Updated calls in MyDatabasePilot.cfm and Application.cfm

Index: thisDatabaseName.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/thisDatabaseName.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** thisDatabaseName.cfm	18 May 2003 04:46:12 -0000	1.2
--- thisDatabaseName.cfm	20 May 2003 04:22:10 -0000	1.3
***************
*** 1,5 ****
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/LockRequired/thisDatabaseName.cfm (CUSTOM TAG)                       *
  * Purpose:          Creates a Record Set with the name of the current database                 *
  * Inputs:           - queryName (Required)                                                     *
--- 1,5 ----
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/thisDatabaseName.cfm (CUSTOM TAG)                                    *
  * Purpose:          Creates a Record Set with the name of the current database                 *
  * Inputs:           - queryName (Required)                                                     *

[Mydatabasepilot-cvs] MyDatabasePilot/Query SELECT.cfm,1.2,1.3

[<nan...@us...>]

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

Modified Files:
	SELECT.cfm 
Log Message:
Internal Structure Changed:
[ 740223 ] Convert Query/SELECT.cfm to a CUSTOM TAG

Index: SELECT.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/SELECT.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** SELECT.cfm	9 May 2003 04:08:02 -0000	1.2
--- SELECT.cfm	20 May 2003 03:29:46 -0000	1.3
***************
*** 1,123 ****
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/SELECT.cfm                                                           *
  * Purpose:          - Creates a Record Set with a Dynamic Select Statement                     *
  *                   - Everything from the Query Name, to the selected fields, to the selected  *
! *                     tables, limit records are dynamic, therefore all these parameter must be *
! *                     provided, when calling this template                                     *
! * Requiremets:      - Connection Variables must already be set                                 *
! *                   - queryName must have been passed to current template as either of Scope   *
! *                     URL or FORM                                                              *
! *                   - Selected fields can either be passed or else it is assumed that all      *
  *                     fields "*" are required                                                  *
  *                   - Either Table names or the select list string must have been Passed to    *
  *                     overite default "*"                                                      *
  ********************************************************************************************--->
- <!---------------------->
- <!--- Error Checking --->
- <!---------------------->
- <!--- Check that either a table(s) name exists or that a select string is provided to overwrite default "*" --->
- 
- <!------------------------------------------------->
- <!--- Generate Select Statement Clause Strings --->
- <!------------------------------------------------->
- <!---||| Select Options List String |||--->
- <cfparam name="selectOptionsString" default="">
- 
- <!---||| Select List Clause String |||--->
- <!--- This is the only clause that is required by MySQL --->
- <!--- We set it to the default of "*", which means all columns from the tables named in the FROM clause --->
- <cfparam name="selectListString" default="*">
- 
- <!---||| Into Outfile Clause String |||--->
- <cfparam name="intoOutfileString" default="">
- 
- <!---||| From Clause String |||--->
- <!--- Set Default to Empty String --->
- <cfparam name="fromString" default="">
- <!--- Check to see if table value exists, scope is not specified because it could be a Local, URL, or FORM variable --->
- <cfif IsDefined("table")>
- 	<!--- Add Table to fromString --->
- 	<cfset fromString = "#table#">
- </cfif>
- 
- <!---||| Where Clause String |||--->
- <cfparam name="whereString" default="">
- 
- <!---||| Group By Clause String |||--->
- <cfparam name="groupByString" default="">
- 
- <!---||| Having Clause String |||--->
- <cfparam name="havingString" default="">
- 
- <!---||| Order By Clause String |||--->
- <cfparam name="orderByString" default="">
- 
- <!---||| Limit Clause String |||--->
- <cfparam name="limitString" default="">
- <!--- Check to see if numberOfRecords value exists, scope is not specified because it could be a Local, URL, or FORM variable --->
- <cfif IsDefined("numberOfRecords")>
- 	<!--- Check to see if starting record is specified, scope is not declared because it could be a Local, URL, or FORM variable --->
- 	<cfif IsDefined("initialRecord")>
- 		<!--- Add start record to limitString --->
- 		<cfset limitString = "#initialRecord#, ">
- 	</cfif>
- 	<!--- Add number of records to return to limitString --->
- 	<cfset limitString = "#limitString##numberOfRecords#">
- </cfif>
  
! <!---||| Procedure Clause String |||--->
! <cfparam name="procedureString" default="">
! 
! <!-------------------------------->
! <!--- Execute Select Statement --->
! <!-------------------------------->
! <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
! 	<!--- Creates a Record Set with a Dynamic Select Statement --->
! 	<!--- Query Name is Dynamic and must be provided to this generic template --->
! 	<cfquery name="#queryName#" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
! 		<!--- Select Statement --->
! 		SELECT
! 		<!--- List Select Options If Any --->
! 		<cfif selectOptionsString IS NOT "">
! 			#selectOptionsString#
! 		</cfif>
! 		<!--- Select List Clause (Required) --->
! 		#selectListString#
! 		<!--- Add Into Outfile Clause If Any --->
! 		<cfif intoOutfileString IS NOT "">
! 			INTO OUTFILE #intoOutfileString#
! 		</cfif>
! 		<!--- Add From Clause If Any --->
! 		<cfif fromString IS NOT "">
! 			FROM #fromString#
! 		</cfif>
! 		<!--- Add Where Clause If Any --->
! 		<cfif whereString IS NOT "">
! 			WHERE #whereString#
! 		</cfif>
! 		<!--- Add Group By If Any --->
! 		<cfif groupByString IS NOT "">
! 			GROUP BY #groupByString#
! 		</cfif>
! 		<!--- Add Having Clause If Any --->
! 		<cfif havingString IS NOT "">
! 			HAVING #havingString#
! 		</cfif>
! 		<!--- Add Order By Clause If Any --->
! 		<cfif orderByString IS NOT "">
! 			ORDER BY #orderByString#
! 		</cfif>
! 		<!--- Add Limit Clause If Any --->
! 		<cfif limitString IS NOT "">
! 			LIMIT #limitString#
  		</cfif>
! 		<!--- Add Procedure Clause If Any --->
! 		<cfif procedureString IS NOT "">
! 			PROCEDURE #procedureString#
  		</cfif>
! 		<!--- End SQL Statement --->
! 		;
! 	</cfquery>
! </cflock>
\ No newline at end of file
--- 1,138 ----
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/SELECT.cfm (Custom Tag)                                              *
  * Purpose:          - Creates a Record Set with a Dynamic Select Statement                     *
  *                   - Everything from the Query Name, to the selected fields, to the selected  *
! *                     tables, limit records are dynamic                                        *
! * Inputs Required:  - queryName       String                                                   *
! *                   - dataSource      String                                                   *
! *                   - userName        String                                                   *
! *                   - password        String                                                   *
! * Inputs Optional:  - tables          List (Comma Delimited)                                   *
! *					- initialRecord   Integer                                                  *
! *                   - numberOfRecords Integer                                                  *
! * Outputs:          - queryName       Query Result Set                                         *
! * Other Requirements- Selected fields can either be passed or else it is assumed that all      *
  *                     fields "*" are required                                                  *
  *                   - Either Table names or the select list string must have been Passed to    *
  *                     overite default "*"                                                      *
+ *                   - This Custom Tag requires an end tag                                      *
  ********************************************************************************************--->
  
! <!---||| Determine which execution mode this custom tag is in |||--->
! <cfswitch expression="#ThisTag.ExecutionMode#">
! 	<!---||| If in start mode ... |||--->
! 	<cfcase value="start">
! 		<!---------------------->
! 		<!--- Error Checking --->
! 		<!---------------------->
! 		<!---||| Check to make sure end tag exists |||--->
! 		<!---||| More user friendly error checking will be introduced in the BETA releases |||--->
! 		<cfif NOT ThisTag.HasEndTag><CFABORT showerror="The SELECT custom tag requires an end tag."></cfif>
! 		
! 		<!---||| Check for existence of Required Attributes |||--->
! 		<cfif NOT IsDefined("ATTRIBUTES.queryName")><CFABORT showerror="The queryName attribute is required when calling SELECT custom tag."></cfif>
! 		<cfif NOT IsDefined("ATTRIBUTES.dataSource")><CFABORT showerror="The dataSource attribute is required when calling SELECT custom tag."></cfif>
! 		<cfif NOT IsDefined("ATTRIBUTES.userName")><CFABORT showerror="The userName attribute is required when calling SELECT custom tag."></cfif>
! 		<cfif NOT IsDefined("ATTRIBUTES.password")><CFABORT showerror="The password attribute is required when calling SELECT custom tag."></cfif>
! 		
! 		<!---||| Check that at least one table name exists or that a select string is provided to overwrite default "*" |||--->
! 			<!--- This needs to be developed --->
! 			
! 		<!---||| Check for proper data types, to ensure SQL syntax is correct |||--->
! 			<!--- This needs to be developed --->
! 		
! 		<!------------------------------------------------->
! 		<!--- Generate Select Statement Clause Strings --->
! 		<!------------------------------------------------->
! 		<!---||| Select Options List String |||--->
! 		<cfparam name="selectOptionsString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Select List Clause String |||--->
! 		<!--- This is the only clause that is required by MySQL --->
! 		<!--- We set it to the default of "*", which means all columns from the tables named in the FROM clause --->
! 		<cfparam name="selectListString" default="*">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Into Outfile Clause String |||--->
! 		<cfparam name="intoOutfileString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| From Clause String |||--->
! 		<!--- Set Default to Empty String --->
! 		<cfparam name="fromString" default="">
! 		<!--- Check to see if table value exists --->
! 		<cfif IsDefined("ATTRIBUTES.tables")>
! 			<!--- Add Tables to fromString --->
! 			<cfset fromString = ATTRIBUTES.tables>
  		</cfif>
! 		
! 		<!---||| Where Clause String |||--->
! 		<cfparam name="whereString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Group By Clause String |||--->
! 		<cfparam name="groupByString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Having Clause String |||--->
! 		<cfparam name="havingString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Order By Clause String |||--->
! 		<cfparam name="orderByString" default="">
! 			<!--- Input processing needs to be developed --->
! 		
! 		<!---||| Limit Clause String |||--->
! 		<cfparam name="limitString" default="">
! 		<!--- Check to see if numberOfRecords value exists --->
! 		<cfif IsDefined("ATTRIBUTES.numberOfRecords")>
! 			<!--- Check to see if starting record is specified --->
! 			<cfif IsDefined("ATTRIBUTES.initialRecord")>
! 				<!--- Add start record to limitString --->
! 				<cfset limitString = "#ATTRIBUTES.initialRecord#, ">
! 			</cfif>
! 			<!--- Add number of records to return to limitString --->
! 			<cfset limitString = "#limitString##ATTRIBUTES.numberOfRecords#">
  		</cfif>
! 		
! 		<!---||| Procedure Clause String |||--->
! 		<cfparam name="procedureString" default="">
! 			<!--- Input processing needs to be developed --->
! 	</cfcase>
! 	
! 	<!---||| If in end mode ... |||--->
! 	<cfcase value="end">
! 		<!-------------------------------->
! 		<!--- Execute Select Statement --->
! 		<!-------------------------------->
! 		<!---||| Creates a Record Set with a Dynamic Select Statement |||--->
! 		<cfquery name="CALLER.#ATTRIBUTES.queryName#" datasource="#ATTRIBUTES.dataSource#" username="#ATTRIBUTES.userName#" password="#ATTRIBUTES.password#">
! 			<!--- Select Statement --->
! 			SELECT
! 			<!--- List Select Options If Any --->
! 			<cfif selectOptionsString IS NOT "">#selectOptionsString#</cfif>
! 			<!--- Select List Clause (Required) --->
! 			#selectListString#
! 			<!--- Add Into Outfile Clause If Any --->
! 			<cfif intoOutfileString IS NOT "">INTO OUTFILE #intoOutfileString#</cfif>
! 			<!--- Add From Clause If Any --->
! 			<cfif fromString IS NOT "">FROM #fromString#</cfif>
! 			<!--- Add Where Clause If Any --->
! 			<cfif whereString IS NOT "">WHERE #whereString#</cfif>
! 			<!--- Add Group By If Any --->
! 			<cfif groupByString IS NOT "">GROUP BY #groupByString#</cfif>
! 			<!--- Add Having Clause If Any --->
! 			<cfif havingString IS NOT "">HAVING #havingString#</cfif>
! 			<!--- Add Order By Clause If Any --->
! 			<cfif orderByString IS NOT "">ORDER BY #orderByString#</cfif>
! 			<!--- Add Limit Clause If Any --->
! 			<cfif limitString IS NOT "">LIMIT #limitString#</cfif>
! 			<!--- Add Procedure Clause If Any --->
! 			<cfif procedureString IS NOT "">PROCEDURE #procedureString#</cfif>
! 			<!--- End SQL Statement --->
! 			;
! 		</cfquery>
! 	</cfcase>
! </cfswitch>
\ No newline at end of file

[Mydatabasepilot-cvs] MyDatabasePilot MyDatabasePilot.cfm,1.14,1.15

[<nan...@us...>]

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

Modified Files:
	MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 740223 ] Convert Query/SELECT.cfm to a CUSTOM TAG

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** MyDatabasePilot.cfm	18 May 2003 04:46:12 -0000	1.14
--- MyDatabasePilot.cfm	20 May 2003 03:29:46 -0000	1.15
***************
*** 131,138 ****
  				password="#SESSION.password#"
  				table="#URL.table#">
  		</cflock>
- 		<!--- Retrieve the requested records --->
- 		<cfset queryName = "selectedData">
- 		<cfinclude template="Query/SELECT.cfm">
  	</cfcase>
  	<cfcase value="CreateTable_Step1"></cfcase>
--- 131,145 ----
  				password="#SESSION.password#"
  				table="#URL.table#">
+ 			<!--- Get Requested Records --->
+ 			<cfmodule template="Query/SELECT.cfm"
+ 				queryName="selectedData"
+ 				datasource="#SESSION.dataSource#"
+ 				username="#SESSION.userName#"
+ 				password="#SESSION.password#"
+ 				tables="#URL.table#"
+ 				initialRecord="#initialRecord#"
+ 				numberOfRecords="#numberOfRecords#">
+ 			</cfmodule>
  		</cflock>
  	</cfcase>
  	<cfcase value="CreateTable_Step1"></cfcase>

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.12,1.13 MyDatabasePilot.cfm,1.13,1.14

[<nan...@us...>]

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

Modified Files:
	Application.cfm MyDatabasePilot.cfm 
Log Message:
Internal Structure Changed:
[ 739341 ] Convert Query/LockRequired/thisDatabaseName.cfm to a CUSTOM TAG

Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** Application.cfm	9 May 2003 04:16:36 -0000	1.12
--- Application.cfm	18 May 2003 04:46:12 -0000	1.13
***************
*** 2,6 ****
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
  * Template:         Application.cfm                                                            *
! * Purpose:          - Creates Client variables for connecting to database                      *		
  *                   - Application wide variables, functions and errorhandling                  *
  ********************************************************************************************--->
--- 2,7 ----
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
  * Template:         Application.cfm                                                            *
! * Purpose:          - Creates Client variables for personalization                             *		
! *                   - Creates Session variables for connecting to database                     *
  *                   - Application wide variables, functions and errorhandling                  *
  ********************************************************************************************--->
***************
*** 35,45 ****
  <!---------------------------------------->
  <!--- Initiate an Exclusive lock to ensure the integrity of Application variables --->
! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "application">
  	<!--- Ensure Application Name has not Expired --->
! 	<cfif NOT IsDefined("application.name")><cfset application.name = "MyDatabase Pilot"></cfif>
  	<!--- Ensure Application Version has not Expired --->
! 	<cfif NOT IsDefined("application.version")><cfset application.version = "v0.7.1(Alpha)"></cfif>
  	<!--- Ensure Application Release Date has not Expired --->
! 	<cfif NOT IsDefined("application.releaseDate")><cfset application.releaseDate = "9 May 2003"></cfif>
  </cflock>
  
--- 36,46 ----
  <!---------------------------------------->
  <!--- Initiate an Exclusive lock to ensure the integrity of Application variables --->
! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "APPLICATION">
  	<!--- Ensure Application Name has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.name")><cfset application.name = "MyDatabase Pilot"></cfif>
  	<!--- Ensure Application Version has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.version")><cfset application.version = "v0.7.1(Alpha)"></cfif>
  	<!--- Ensure Application Release Date has not Expired --->
! 	<cfif NOT IsDefined("APPLICATION.releaseDate")><cfset application.releaseDate = "9 May 2003"></cfif>
  </cflock>
  
***************
*** 50,56 ****
  <cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "exclusive">
  	<!--- Used to limit number of records returned from a query --->
! 	<cfparam name="client.defaultMaxRows" default=20>
  	<!--- Used to repeat the table headers after specified number of rows/records --->
! 	<cfparam name="client.defaultRepeatHeaders" default="50">
  </cflock>
  
--- 51,57 ----
  <cflock name="clientDefaultSettings" timeout = "30" throwontimeout="no" type = "exclusive">
  	<!--- Used to limit number of records returned from a query --->
! 	<cfparam name="CLIENT.defaultMaxRows" default=20>
  	<!--- Used to repeat the table headers after specified number of rows/records --->
! 	<cfparam name="CLIENT.defaultRepeatHeaders" default="50">
  </cflock>
  
***************
*** 64,93 ****
  to much time on this.)--->
  <!--- Initiate an Exclusive lock to ensure the integrity of Session variables --->
! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
  	<!---||| Initialize connection variables used by queries to connect to the database |||--->
  	<!--- If dataSource does not exist ... --->
! 	<cfif NOT IsDefined("session.dataSource")>
  		<!--- NOTE FOR DEFAULT DATABASE USERS:
  		If you choose to configure a default database, you must set the dataSource, userName and password
  		variables to an actual database that you have complete access to --->
  		<!--- Initialize connection variables --->
! 		<cfset session.dataSource = "">	<!--- Enter default Data Source --->
! 		<cfset session.userName = "">	<!--- Enter default User Name --->
! 		<cfset session.password = "">	<!--- Enter default password --->
  	</cfif>
  
  	<!---||| Ensure User is Logged In and Session has not Expired |||--->
  	<!--- If session is new or has expired ... --->
! 	<cfif NOT IsDefined("session.loggedIn")>
  		<!--- Check if default dataSource was configured --->
  		<!--- If dataSource is empty string ... --->
! 		<cfif session.dataSource IS "">
  			<!--- this would indicate that no default data source was provided and user is not logged into any datasource --->
! 			<cfset session.loggedIn = 0>
  			<!--- Redirect User to login form --->
  			<cflocation url="index.cfm">
  		<cfelse>
  			<!--- Otherwise user is logged in using default datasource configuration --->
! 			<cfset session.loggedIn = 1>
  		</cfif>
  	</cfif>
--- 65,94 ----
  to much time on this.)--->
  <!--- Initiate an Exclusive lock to ensure the integrity of Session variables --->
! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "SESSION">
  	<!---||| Initialize connection variables used by queries to connect to the database |||--->
  	<!--- If dataSource does not exist ... --->
! 	<cfif NOT IsDefined("SESSION.dataSource")>
  		<!--- NOTE FOR DEFAULT DATABASE USERS:
  		If you choose to configure a default database, you must set the dataSource, userName and password
  		variables to an actual database that you have complete access to --->
  		<!--- Initialize connection variables --->
! 		<cfset SESSION.dataSource = "">	<!--- Enter default Data Source --->
! 		<cfset SESSION.userName = "">	<!--- Enter default User Name --->
! 		<cfset SESSION.password = "">	<!--- Enter default password --->
  	</cfif>
  
  	<!---||| Ensure User is Logged In and Session has not Expired |||--->
  	<!--- If session is new or has expired ... --->
! 	<cfif NOT IsDefined("SESSION.loggedIn")>
  		<!--- Check if default dataSource was configured --->
  		<!--- If dataSource is empty string ... --->
! 		<cfif SESSION.dataSource IS "">
  			<!--- this would indicate that no default data source was provided and user is not logged into any datasource --->
! 			<cfset SESSION.loggedIn = 0>
  			<!--- Redirect User to login form --->
  			<cflocation url="index.cfm">
  		<cfelse>
  			<!--- Otherwise user is logged in using default datasource configuration --->
! 			<cfset SESSION.loggedIn = 1>
  		</cfif>
  	</cfif>
***************
*** 95,103 ****
  	<!---||| Initialize dbName |||--->
  	<!--- If dbName does not exist, and user is logged in ... --->
! 	<cfif NOT IsDefined("session.dbName") AND session.loggedIn IS TRUE>
! 		<!--- Find out the Database Name by calling thisDatabaseName Query --->
! 		<cfinclude template="Query/LockRequired/thisDatabaseName.cfm">
  		<!--- Set dbName Variable with result of thisDatabaseName Query --->
! 		<cfset session.dbName = "#thisDatabaseName.databaseName#">
  	</cfif>
  </cflock>
--- 96,108 ----
  	<!---||| Initialize dbName |||--->
  	<!--- If dbName does not exist, and user is logged in ... --->
! 	<cfif NOT IsDefined("SESSION.dbName") AND SESSION.loggedIn IS TRUE>
! 		<!--- Get Database Name --->
! 		<cfmodule template="Query/LockRequired/thisDatabaseName.cfm"
! 			queryName="thisDatabaseName"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
  		<!--- Set dbName Variable with result of thisDatabaseName Query --->
! 		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
  	</cfif>
  </cflock>
***************
*** 107,112 ****
  <!--------------------------------------------------------->
  <cfset mainpage = "MyDatabasePilot.cfm">
! <cfset currentPath = "#cgi.path_info#">
! <cfset currentQueryString = "#cgi.query_string#">
  <cfset currentPage = "#currentPath#?#currentQueryString#">
  <!--- The Main Menu is Visible by Default --->
--- 112,117 ----
  <!--------------------------------------------------------->
  <cfset mainpage = "MyDatabasePilot.cfm">
! <cfset currentPath = "#CGI.path_info#">
! <cfset currentQueryString = "#CGI.query_string#">
  <cfset currentPage = "#currentPath#?#currentQueryString#">
  <!--- The Main Menu is Visible by Default --->

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** MyDatabasePilot.cfm	16 May 2003 02:39:06 -0000	1.13
--- MyDatabasePilot.cfm	18 May 2003 04:46:12 -0000	1.14
***************
*** 24,29 ****
  		<!--- Set the loggedIn Flag to True --->
  		<cfset SESSION.loggedIn = 1>
! 		<!--- Find out the Database Name and Overwrite dbName Variable --->
! 		<cfinclude template="Query/LockRequired/thisDatabaseName.cfm">
  		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
  	</cflock>
--- 24,34 ----
  		<!--- Set the loggedIn Flag to True --->
  		<cfset SESSION.loggedIn = 1>
! 		<!--- Get Database Name --->
! 		<cfmodule template="Query/LockRequired/thisDatabaseName.cfm"
! 			queryName="thisDatabaseName"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
! 		<!--- Overwrite dbName Variable --->
  		<cfset SESSION.dbName = "#thisDatabaseName.databaseName#">
  	</cflock>
***************
*** 35,48 ****
  <!--- Which dbProcess was requested? --->
  <cfswitch expression="#dbProcess#">
! 	<!---||| If ShowTables ... |||--->
! 	<cfcase value="ShowTables">
! 		<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 		<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 			<!--- Get List of Table Names --->
! 			<cfmodule template="Query/tableList.cfm"
! 				queryName="tableList"
! 				datasource="#SESSION.dataSource#"
! 				username="#SESSION.userName#"
! 				password="#SESSION.password#">
  		</cflock>
  	</cfcase>
--- 40,53 ----
  <!--- Which dbProcess was requested? --->
  <cfswitch expression="#dbProcess#">
! <!---||| If ShowTables ... |||--->
! <cfcase value="ShowTables">
! 	<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! 	<cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 		<!--- Get List of Table Names --->
! 		<cfmodule template="Query/tableList.cfm"
! 			queryName="tableList"
! 			datasource="#SESSION.dataSource#"
! 			username="#SESSION.userName#"
! 			password="#SESSION.password#">
  		</cflock>
  	</cfcase>

[Mydatabasepilot-cvs] MyDatabasePilot/Query/LockRequired thisDatabaseName.cfm,1.1,1.2

[<nan...@us...>]

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query/LockRequired
In directory sc8-pr-cvs1:/tmp/cvs-serv15409/Query/LockRequired

Modified Files:
	thisDatabaseName.cfm 
Log Message:
Internal Structure Changed:
[ 739341 ] Convert Query/LockRequired/thisDatabaseName.cfm to a CUSTOM TAG

Index: thisDatabaseName.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/LockRequired/thisDatabaseName.cfm,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** thisDatabaseName.cfm	24 Apr 2003 03:07:10 -0000	1.1
--- thisDatabaseName.cfm	18 May 2003 04:46:12 -0000	1.2
***************
*** 1,13 ****
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/LockRequired/thisDatabaseName.cfm                                    *
  * Purpose:          Creates a Record Set with the name of the current database                 *
! * Requiremets:      - Connection Variables must already be set                                 *
! *                   - This Query Must be called from within a session lock to ensure the       *
! *                   integrity of session variables                                             *
  ********************************************************************************************--->
  
  <!---||| Create a Record Set with the name of the current database |||--->
! <cfquery name="thisDatabaseName" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
  	SELECT DATABASE() AS databaseName;
  </cfquery>
--- 1,22 ----
  <!---*******************************************************************************************
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
! * Template:         Query/LockRequired/thisDatabaseName.cfm (CUSTOM TAG)                       *
  * Purpose:          Creates a Record Set with the name of the current database                 *
! * Inputs:           - queryName (Required)                                                     *
! *                   - dataSource (Required)                                                    *
! *                   - userName (Required)                                                      *
! *                   - password (Required)                                                      *
! * Outputs:          - queryName                                                                *
  ********************************************************************************************--->
  
+ <!---||| Check for existence of Required Attributes |||--->
+ <!---||| More user friendly error checking will be introduced in the BETA releases |||--->
+ <cfif NOT IsDefined("ATTRIBUTES.queryName")><CFABORT showerror="The queryName attribute is required when calling thisDatabaseName custom tag."></cfif>
+ <cfif NOT IsDefined("ATTRIBUTES.dataSource")><CFABORT showerror="The dataSource attribute is required when calling thisDatabaseName custom tag."></cfif>
+ <cfif NOT IsDefined("ATTRIBUTES.userName")><CFABORT showerror="The userName attribute is required when calling thisDatabaseName custom tag."></cfif>
+ <cfif NOT IsDefined("ATTRIBUTES.password")><CFABORT showerror="The password attribute is required when calling thisDatabaseName custom tag."></cfif>
+ 
  <!---||| Create a Record Set with the name of the current database |||--->
! <cfquery name="CALLER.#ATTRIBUTES.queryName#" datasource="#ATTRIBUTES.dataSource#" username="#ATTRIBUTES.userName#" password="#ATTRIBUTES.password#">
  	SELECT DATABASE() AS databaseName;
  </cfquery>

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

[<nan...@us...>]

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

Modified Files:
	EnvDatabase.cfm 
Log Message:
Internal Structure Changed:
[ 739068 ] Convert Query/dbGeneralInfo.cfm to a CUSTOM TAG

Index: EnvDatabase.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/EnvDatabase.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** EnvDatabase.cfm	30 Apr 2003 03:39:03 -0000	1.3
--- EnvDatabase.cfm	17 May 2003 06:21:53 -0000	1.4
***************
*** 7,11 ****
  
  <!---||| Run Page Specific Queries |||--->
! <cfinclude template="Query/dbGeneralInfo.cfm">	<!--- Creates a record set with basic MySQL server info --->
  
  <!---||| Initialize Local Page Variables |||--->
--- 7,19 ----
  
  <!---||| Run Page Specific Queries |||--->
! <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 	<!--- Get basic MySQL server info --->
! 	<cfmodule template="Query/dbGeneralInfo.cfm"
! 		queryName="dbGeneralInfo"
! 		datasource="#SESSION.dataSource#"
! 		username="#SESSION.userName#"
! 		password="#SESSION.password#">
! </cflock>
  
  <!---||| Initialize Local Page Variables |||--->