[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,1.13,1.14

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

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

Modified Files:
	AddField.cfm 
Log Message:
Cosmetic Change:
[ 763466 ] Moved Default Value Column to be included with Field 
Name and Field Type 

Index: AddField.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/AddField.cfm,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** AddField.cfm	26 Jun 2003 19:15:47 -0000	1.13
--- AddField.cfm	30 Jun 2003 20:31:38 -0000	1.14
***************
*** 54,60 ****
  				<tr>
  					<td><label class="Fancy">Field No:</label></td>
! 					<td><label class="Fancy">Field Name and Type:</label></td>
  					<td><label class="Fancy">Field Options:</label></td>
- 					<td><label class="Fancy">Default Value:</label></td>
  					<td><label class="Fancy">Index:</label></td>
  				</tr>
--- 54,59 ----
  				<tr>
  					<td><label class="Fancy">Field No:</label></td>
! 					<td><label class="Fancy">Field Name, Type, Default:</label></td>
  					<td><label class="Fancy">Field Options:</label></td>
  					<td><label class="Fancy">Index:</label></td>
  				</tr>
***************
*** 68,264 ****
  							<td><label class="Fancy">#i#</label></td>
  
! 							<!---||| Allow User to Specify the Fields Name |||--->
  							<!--- If the form has been resubmitted by an onChange event than the original values for this form will be used --->
  							<td>
! 								<!--- Field Name --->
! 								<!---***Add  validate="regular_expression" to below, to ensure user entered a valid field name***--->
! 								<cfinput name="fieldName#i#" type="text" value="#alterSpec[i].colName#" size="20" maxlength="64" required="yes" message="You must enter a valid field name for New Field number #i#." class="Fancy" /><br />
! 								<!--- Field Type --->
! 								<cfselect name="fieldType#i#" size="1" required="yes" class="Fancy" onChange="this.form.submit()">
! 									<!--- Check to see if empty option was selected, and reselect it accordingly --->
! 									<cfif alterSpec[i].colType IS "">
! 										<option value="Empty" selected class="Fancy"></option>
! 									<cfelse>
! 										<option value="Empty" class="Fancy"></option>
! 									</cfif>
! 									<optgroup label="String" class="Fancy">
! 										<!--- Check to see if VARCHAR option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "VARCHAR">
! 											<option value="VARCHAR" selected class="Fancy">VARCHAR(m)</option>
! 										<cfelse>
! 											<option value="VARCHAR" class="Fancy">VARCHAR(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if CHAR option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "CHAR">	
! 											<option value="CHAR" selected class="Fancy">CHAR(m)</option>
! 										<cfelse>
! 											<option value="CHAR" class="Fancy">CHAR(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if TINYBLOB option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TINYBLOB">
! 											<option value="TINYBLOB" selected class="Fancy">TINYBLOB</option>
! 										<cfelse>
! 											<option value="TINYBLOB" class="Fancy">TINYBLOB</option>
! 										</cfif>
! 										
! 										<!--- Check to see if BLOB option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "BLOB">
! 											<option value="BLOB" selected class="Fancy">BLOB</option>
! 										<cfelse>
! 											<option value="BLOB" class="Fancy">BLOB</option>
! 										</cfif>
! 										
! 										<!--- Check to see if MEDIUMBLOB option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "MEDIUMBLOB">
! 											<option value="MEDIUMBLOB" selected class="Fancy">MEDIUMBLOB</option>
! 										<cfelse>
! 											<option value="MEDIUMBLOB" class="Fancy">MEDIUMBLOB</option>
! 										</cfif>
! 										
! 										<!--- Check to see if LONGBLOB option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "LONGBLOB">
! 											<option value="LONGBLOB" selected class="Fancy">LONGBLOB</option>
! 										<cfelse>
! 											<option value="LONGBLOB" class="Fancy">LONGBLOB</option>
! 										</cfif>
! 										
! 										<!--- Check to see if TINYTEXT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TINYTEXT">
! 											<option value="TINYTEXT" selected class="Fancy">TINYTEXT</option>
! 										<cfelse>
! 											<option value="TINYTEXT" class="Fancy">TINYTEXT</option>
! 										</cfif>
! 										
! 										<!--- Check to see if TEXT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TEXT">
! 											<option value="TEXT" selected class="Fancy">TEXT</option>
! 										<cfelse>
! 											<option value="TEXT" class="Fancy">TEXT</option>
! 										</cfif>
! 										
! 										<!--- Check to see if MEDIUMTEXT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "MEDIUMTEXT">
! 											<option value="MEDIUMTEXT" selected class="Fancy">MEDIUMTEXT</option>
! 										<cfelse>
! 											<option value="MEDIUMTEXT" class="Fancy">MEDIUMTEXT</option>
! 										</cfif>
! 										
! 										<!--- Check to see if LONGTEXT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "LONGTEXT">
! 											<option value="LONGTEXT" selected class="Fancy">LONGTEXT</option>
! 										<cfelse>
! 											<option value="LONGTEXT" class="Fancy">LONGTEXT</option>
! 										</cfif>
! 										
! 										<!--- Check to see if ENUM option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "ENUM">
! 											<option value="ENUM" selected class="Fancy">ENUM(v1,v2,...)</option>
! 										<cfelse>
! 											<option value="ENUM" class="Fancy">ENUM(v1,v2,...)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if SET option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "SET">
! 											<option value="SET" selected class="Fancy">SET(v1,v2,...)</option>
! 										<cfelse>
! 											<option value="SET" class="Fancy">SET(v1,v2,...)</option>
! 										</cfif>
! 									</optgroup>
! 									<optgroup label="Numeric" class="Fancy">
! 										<!--- Check to see if TINYINT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TINYINT">
! 											<option value="TINYINT" selected class="Fancy">TINYINT(m)</option>
! 										<cfelse>
! 											<option value="TINYINT" class="Fancy">TINYINT(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if SMALLINT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "SMALLINT">
! 											<option value="SMALLINT" selected class="Fancy">SMALLINT(m)</option>
! 										<cfelse>
! 											<option value="SMALLINT" class="Fancy">SMALLINT(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if MEDIUMINT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "MEDIUMINT">
! 											<option value="MEDIUMINT" selected class="Fancy">MEDIUMINT(m)</option>
! 										<cfelse>
! 											<option value="MEDIUMINT" class="Fancy">MEDIUMINT(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if INT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "INT">
! 											<option value="INT" selected class="Fancy">INT(m)</option>
! 										<cfelse>
! 											<option value="INT" class="Fancy">INT(m)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if BIGINT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "BIGINT">
! 											<option value="BIGINT" selected class="Fancy">BIGINT(m)</option>
! 										<cfelse>
! 											<option value="BIGINT" class="Fancy">BIGINT(m)</option>
! 										</cfif>
! 
! 										<!--- Check to see if FLOAT option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "FLOAT">
! 											<option value="FLOAT" selected class="Fancy">FLOAT(m,d)</option>
! 										<cfelse>
! 											<option value="FLOAT" class="Fancy">FLOAT(m,d)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if DOUBLE option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "DOUBLE">
! 											<option value="DOUBLE" selected class="Fancy">DOUBLE(m,d)</option>
! 										<cfelse>
! 											<option value="DOUBLE" class="Fancy">DOUBLE(m,d)</option>
! 										</cfif>
! 										
! 										<!--- Check to see if DECIMAL option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "DECIMAL">
! 											<option value="DECIMAL" selected class="Fancy">DECIMAL(m,d)</option>
! 										<cfelse>
! 											<option value="DECIMAL" class="Fancy">DECIMAL(m,d)</option>
! 										</cfif>
! 									</optgroup>
! 									<optgroup label="Date Time" class="Fancy">
! 										<!--- Check to see if DATE option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "DATE">
! 											<option value="DATE" selected class="Fancy">DATE</option>
! 										<cfelse>
! 											<option value="DATE" class="Fancy">DATE</option>
! 										</cfif>
! 										
! 										<!--- Check to see if TIME option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TIME">
! 											<option value="TIME" selected class="Fancy">TIME</option>
! 										<cfelse>
! 											<option value="TIME" class="Fancy">TIME</option>
! 										</cfif>
! 										
! 										<!--- Check to see if DATETIME option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "DATETIME">
! 											<option value="DATETIME" selected class="Fancy">DATETIME</option>
! 										<cfelse>
! 											<option value="DATETIME" class="Fancy">DATETIME</option>
! 										</cfif>
! 										
! 										<!--- Check to see if YEAR option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "YEAR">
! 											<option value="YEAR" selected class="Fancy">YEAR</option>
! 										<cfelse>
! 											<option value="YEAR" class="Fancy">YEAR</option>
! 										</cfif>
! 										
! 										<!--- Check to see if TIMESTAMP option was selected, and reselect it accordingly --->
! 										<cfif alterSpec[i].colType IS "TIMESTAMP">
! 											<option value="TIMESTAMP" selected class="Fancy">TIMESTAMP(m)</option>
! 										<cfelse>
! 											<option value="TIMESTAMP" class="Fancy">TIMESTAMP(m)</option>
! 										</cfif>
! 									</optgroup>
! 								</cfselect>
  							</td>
  							
--- 67,288 ----
  							<td><label class="Fancy">#i#</label></td>
  
! 							<!---||| Allow User to Specify the Fields Name, Type and Default Value |||--->
  							<!--- If the form has been resubmitted by an onChange event than the original values for this form will be used --->
  							<td>
! 								<table width="100%" border="0" cellpadding="0" cellspacing="0">
! 									<!--- Field Name --->
! 									<!---***Add  validate="regular_expression" to below, to ensure user entered a valid field name***--->
! 									<tr>
! 										<td><label for="fieldName#i#" class="Fancy">Field Name:</label></td>
! 										<td><cfinput name="fieldName#i#" type="text" value="#alterSpec[i].colName#" size="20" maxlength="64" required="yes" message="You must enter a valid field name for New Field number #i#." class="Fancy" /></td>
! 									</tr>
! 									
! 									<!--- Field Type --->
! 									<tr>
! 										<td><label for="fieldType#i#" class="Fancy">Field Type:</label></td>
! 										<td>
! 											<cfselect name="fieldType#i#" size="1" required="yes" class="Fancy" onChange="this.form.submit()">
! 												<!--- Check to see if empty option was selected, and reselect it accordingly --->
! 												<cfif alterSpec[i].colType IS "">
! 													<option value="Empty" selected class="Fancy"></option>
! 												<cfelse>
! 													<option value="Empty" class="Fancy"></option>
! 												</cfif>
! 												<optgroup label="String" class="Fancy">
! 													<!--- Check to see if VARCHAR option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "VARCHAR">
! 														<option value="VARCHAR" selected class="Fancy">VARCHAR(m)</option>
! 													<cfelse>
! 														<option value="VARCHAR" class="Fancy">VARCHAR(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if CHAR option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "CHAR">	
! 														<option value="CHAR" selected class="Fancy">CHAR(m)</option>
! 													<cfelse>
! 														<option value="CHAR" class="Fancy">CHAR(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if TINYBLOB option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TINYBLOB">
! 														<option value="TINYBLOB" selected class="Fancy">TINYBLOB</option>
! 													<cfelse>
! 														<option value="TINYBLOB" class="Fancy">TINYBLOB</option>
! 													</cfif>
! 													
! 													<!--- Check to see if BLOB option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "BLOB">
! 														<option value="BLOB" selected class="Fancy">BLOB</option>
! 													<cfelse>
! 														<option value="BLOB" class="Fancy">BLOB</option>
! 													</cfif>
! 													
! 													<!--- Check to see if MEDIUMBLOB option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "MEDIUMBLOB">
! 														<option value="MEDIUMBLOB" selected class="Fancy">MEDIUMBLOB</option>
! 													<cfelse>
! 														<option value="MEDIUMBLOB" class="Fancy">MEDIUMBLOB</option>
! 													</cfif>
! 													
! 													<!--- Check to see if LONGBLOB option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "LONGBLOB">
! 														<option value="LONGBLOB" selected class="Fancy">LONGBLOB</option>
! 													<cfelse>
! 														<option value="LONGBLOB" class="Fancy">LONGBLOB</option>
! 													</cfif>
! 													
! 													<!--- Check to see if TINYTEXT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TINYTEXT">
! 														<option value="TINYTEXT" selected class="Fancy">TINYTEXT</option>
! 													<cfelse>
! 														<option value="TINYTEXT" class="Fancy">TINYTEXT</option>
! 													</cfif>
! 													
! 													<!--- Check to see if TEXT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TEXT">
! 														<option value="TEXT" selected class="Fancy">TEXT</option>
! 													<cfelse>
! 														<option value="TEXT" class="Fancy">TEXT</option>
! 													</cfif>
! 													
! 													<!--- Check to see if MEDIUMTEXT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "MEDIUMTEXT">
! 														<option value="MEDIUMTEXT" selected class="Fancy">MEDIUMTEXT</option>
! 													<cfelse>
! 														<option value="MEDIUMTEXT" class="Fancy">MEDIUMTEXT</option>
! 													</cfif>
! 													
! 													<!--- Check to see if LONGTEXT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "LONGTEXT">
! 														<option value="LONGTEXT" selected class="Fancy">LONGTEXT</option>
! 													<cfelse>
! 														<option value="LONGTEXT" class="Fancy">LONGTEXT</option>
! 													</cfif>
! 													
! 													<!--- Check to see if ENUM option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "ENUM">
! 														<option value="ENUM" selected class="Fancy">ENUM(v1,v2,...)</option>
! 													<cfelse>
! 														<option value="ENUM" class="Fancy">ENUM(v1,v2,...)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if SET option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "SET">
! 														<option value="SET" selected class="Fancy">SET(v1,v2,...)</option>
! 													<cfelse>
! 														<option value="SET" class="Fancy">SET(v1,v2,...)</option>
! 													</cfif>
! 												</optgroup>
! 												<optgroup label="Numeric" class="Fancy">
! 													<!--- Check to see if TINYINT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TINYINT">
! 														<option value="TINYINT" selected class="Fancy">TINYINT(m)</option>
! 													<cfelse>
! 														<option value="TINYINT" class="Fancy">TINYINT(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if SMALLINT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "SMALLINT">
! 														<option value="SMALLINT" selected class="Fancy">SMALLINT(m)</option>
! 													<cfelse>
! 														<option value="SMALLINT" class="Fancy">SMALLINT(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if MEDIUMINT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "MEDIUMINT">
! 														<option value="MEDIUMINT" selected class="Fancy">MEDIUMINT(m)</option>
! 													<cfelse>
! 														<option value="MEDIUMINT" class="Fancy">MEDIUMINT(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if INT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "INT">
! 														<option value="INT" selected class="Fancy">INT(m)</option>
! 													<cfelse>
! 														<option value="INT" class="Fancy">INT(m)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if BIGINT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "BIGINT">
! 														<option value="BIGINT" selected class="Fancy">BIGINT(m)</option>
! 													<cfelse>
! 														<option value="BIGINT" class="Fancy">BIGINT(m)</option>
! 													</cfif>
! 			
! 													<!--- Check to see if FLOAT option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "FLOAT">
! 														<option value="FLOAT" selected class="Fancy">FLOAT(m,d)</option>
! 													<cfelse>
! 														<option value="FLOAT" class="Fancy">FLOAT(m,d)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if DOUBLE option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "DOUBLE">
! 														<option value="DOUBLE" selected class="Fancy">DOUBLE(m,d)</option>
! 													<cfelse>
! 														<option value="DOUBLE" class="Fancy">DOUBLE(m,d)</option>
! 													</cfif>
! 													
! 													<!--- Check to see if DECIMAL option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "DECIMAL">
! 														<option value="DECIMAL" selected class="Fancy">DECIMAL(m,d)</option>
! 													<cfelse>
! 														<option value="DECIMAL" class="Fancy">DECIMAL(m,d)</option>
! 													</cfif>
! 												</optgroup>
! 												<optgroup label="Date Time" class="Fancy">
! 													<!--- Check to see if DATE option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "DATE">
! 														<option value="DATE" selected class="Fancy">DATE</option>
! 													<cfelse>
! 														<option value="DATE" class="Fancy">DATE</option>
! 													</cfif>
! 													
! 													<!--- Check to see if TIME option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TIME">
! 														<option value="TIME" selected class="Fancy">TIME</option>
! 													<cfelse>
! 														<option value="TIME" class="Fancy">TIME</option>
! 													</cfif>
! 													
! 													<!--- Check to see if DATETIME option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "DATETIME">
! 														<option value="DATETIME" selected class="Fancy">DATETIME</option>
! 													<cfelse>
! 														<option value="DATETIME" class="Fancy">DATETIME</option>
! 													</cfif>
! 													
! 													<!--- Check to see if YEAR option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "YEAR">
! 														<option value="YEAR" selected class="Fancy">YEAR</option>
! 													<cfelse>
! 														<option value="YEAR" class="Fancy">YEAR</option>
! 													</cfif>
! 													
! 													<!--- Check to see if TIMESTAMP option was selected, and reselect it accordingly --->
! 													<cfif alterSpec[i].colType IS "TIMESTAMP">
! 														<option value="TIMESTAMP" selected class="Fancy">TIMESTAMP(m)</option>
! 													<cfelse>
! 														<option value="TIMESTAMP" class="Fancy">TIMESTAMP(m)</option>
! 													</cfif>
! 												</optgroup>
! 											</cfselect>
! 										</td>
! 									</tr>
! 									
! 									<!--- Default Value --->
! 									<tr>
! 										<td><label for="defaultValue#i#" class="Fancy">Default Value:</label></td>
! 										<td>
! 											<!--- Allow User to Enter a Default Value for the Field Unless fieldType is BLOB or TEXT --->
! 											<cfswitch expression="#alterSpec[i].colType#">
! 												<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT">
! 													<label class="Fancy">BLOB and TEXT field types can not have default values.</label>
! 												</cfcase>
! 												<cfdefaultcase><cfinput name="defaultValue#i#" value="#alterSpec[i].defaultValue#" type="text" size="20" required="no" class="Fancy" /></cfdefaultcase> 
! 											</cfswitch>
! 										</td>
! 									</tr>
! 								</table>
  							</td>
  							
***************
*** 444,457 ****
  									<!---||| Datatype not selected default display |||--->
  									<cfdefaultcase><label class="Fancy">Select a Field Type to see Field Options</label></cfdefaultcase>
- 								</cfswitch>
- 							</td>
- 							
- 							<!---||| Allow User to Enter a Default Value for the Field Unless fieldType is BLOB or TEXT |||--->
- 							<td>
- 								<cfswitch expression="#alterSpec[i].colType#">
- 									<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT">
- 										<label class="Fancy">BLOB and TEXT field types can not have default values.</label>
- 									</cfcase>
- 									<cfdefaultcase><cfinput name="defaultValue#i#" value="#alterSpec[i].defaultValue#" type="text" size="20" required="no" class="Fancy" /></cfdefaultcase> 
  								</cfswitch>
  							</td>
--- 468,471 ----