[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,1.8,1.9

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

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

Modified Files:
	AddField.cfm 
Log Message:
Internal Structure Changed:
[ 753072 ] Moved FORM.fieldType#i# default setting
From: dbProcessBody/AddField.cfm 
To: dbProcessInit/AddField.cfm 

Also changed value of select field fieldType#i# 
From: #Evaluate("FORM.fieldType#i#")# 
To: alterSpec[i].colType

Index: AddField.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/AddField.cfm,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** AddField.cfm	11 Jun 2003 04:10:37 -0000	1.8
--- AddField.cfm	12 Jun 2003 04:34:42 -0000	1.9
***************
*** 69,74 ****

  							<!---||| Allow User to Specify the Fields Name |||--->
- 							<!--- Set a default value of empty string --->
- 							<cfparam name="FORM.fieldType#i#" default="" />
  							<!--- If the form has been resubmitted by an onChange event than the original values for this form will be used --->
  							<td>
--- 69,72 ----
***************
*** 79,83 ****
  								<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 Evaluate("FORM.fieldType#i#") IS "">
  										<option value="Empty" selected class="Fancy"></option>
  									<cfelse>
--- 77,81 ----
  								<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>
***************
*** 86,90 ****
  									<optgroup label="String" class="Fancy">
  										<!--- Check to see if VARCHAR option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "VARCHAR">
  											<option value="VARCHAR" selected class="Fancy">VARCHAR(m)</option>
  										<cfelse>
--- 84,88 ----
  									<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>
***************
*** 93,97 ****

  										<!--- Check to see if CHAR option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "CHAR">	
  											<option value="CHAR" selected class="Fancy">CHAR(m)</option>
  										<cfelse>
--- 91,95 ----

! 										<cfif alterSpec[i].colType IS "CHAR">	
  											<option value="CHAR" selected class="Fancy">CHAR(m)</option>
  										<cfelse>
***************
*** 100,104 ****

  										<!--- Check to see if TINYBLOB option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TINYBLOB">
  											<option value="TINYBLOB" selected class="Fancy">TINYBLOB</option>
  										<cfelse>
--- 98,102 ----

! 										<cfif alterSpec[i].colType IS "TINYBLOB">
  											<option value="TINYBLOB" selected class="Fancy">TINYBLOB</option>
  										<cfelse>
***************
*** 107,111 ****

  										<!--- Check to see if BLOB option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "BLOB">
  											<option value="BLOB" selected class="Fancy">BLOB</option>
  										<cfelse>
--- 105,109 ----

! 										<cfif alterSpec[i].colType IS "BLOB">
  											<option value="BLOB" selected class="Fancy">BLOB</option>
  										<cfelse>
***************
*** 114,118 ****

  										<!--- Check to see if MEDIUMBLOB option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "MEDIUMBLOB">
  											<option value="MEDIUMBLOB" selected class="Fancy">MEDIUMBLOB</option>
  										<cfelse>
--- 112,116 ----

! 										<cfif alterSpec[i].colType IS "MEDIUMBLOB">
  											<option value="MEDIUMBLOB" selected class="Fancy">MEDIUMBLOB</option>
  										<cfelse>
***************
*** 121,125 ****

  										<!--- Check to see if LONGBLOB option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "LONGBLOB">
  											<option value="LONGBLOB" selected class="Fancy">LONGBLOB</option>
  										<cfelse>
--- 119,123 ----

! 										<cfif alterSpec[i].colType IS "LONGBLOB">
  											<option value="LONGBLOB" selected class="Fancy">LONGBLOB</option>
  										<cfelse>
***************
*** 128,132 ****

  										<!--- Check to see if TINYTEXT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TINYTEXT">
  											<option value="TINYTEXT" selected class="Fancy">TINYTEXT</option>
  										<cfelse>
--- 126,130 ----

! 										<cfif alterSpec[i].colType IS "TINYTEXT">
  											<option value="TINYTEXT" selected class="Fancy">TINYTEXT</option>
  										<cfelse>
***************
*** 135,139 ****

  										<!--- Check to see if TEXT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TEXT">
  											<option value="TEXT" selected class="Fancy">TEXT</option>
  										<cfelse>
--- 133,137 ----

! 										<cfif alterSpec[i].colType IS "TEXT">
  											<option value="TEXT" selected class="Fancy">TEXT</option>
  										<cfelse>
***************
*** 142,146 ****

  										<!--- Check to see if MEDIUMTEXT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "MEDIUMTEXT">
  											<option value="MEDIUMTEXT" selected class="Fancy">MEDIUMTEXT</option>
  										<cfelse>
--- 140,144 ----

! 										<cfif alterSpec[i].colType IS "MEDIUMTEXT">
  											<option value="MEDIUMTEXT" selected class="Fancy">MEDIUMTEXT</option>
  										<cfelse>
***************
*** 149,153 ****

  										<!--- Check to see if LONGTEXT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "LONGTEXT">
  											<option value="LONGTEXT" selected class="Fancy">LONGTEXT</option>
  										<cfelse>
--- 147,151 ----

! 										<cfif alterSpec[i].colType IS "LONGTEXT">
  											<option value="LONGTEXT" selected class="Fancy">LONGTEXT</option>
  										<cfelse>
***************
*** 156,160 ****

  										<!--- Check to see if ENUM option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "ENUM">
  											<option value="ENUM" selected class="Fancy">ENUM(v1,v2,...)</option>
  										<cfelse>
--- 154,158 ----

! 										<cfif alterSpec[i].colType IS "ENUM">
  											<option value="ENUM" selected class="Fancy">ENUM(v1,v2,...)</option>
  										<cfelse>
***************
*** 163,167 ****

  										<!--- Check to see if SET option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "SET">
  											<option value="SET" selected class="Fancy">SET(v1,v2,...)</option>
  										<cfelse>
--- 161,165 ----

  										<!--- 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>
***************
*** 171,175 ****
  									<optgroup label="Numeric" class="Fancy">
  										<!--- Check to see if TINYINT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TINYINT">
  											<option value="TINYINT" selected class="Fancy">TINYINT(m)</option>
  										<cfelse>
--- 169,173 ----
  									<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>
***************
*** 178,182 ****

  										<!--- Check to see if SMALLINT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "SMALLINT">
  											<option value="SMALLINT" selected class="Fancy">SMALLINT(m)</option>
  										<cfelse>
--- 176,180 ----

! 										<cfif alterSpec[i].colType IS "SMALLINT">
  											<option value="SMALLINT" selected class="Fancy">SMALLINT(m)</option>
  										<cfelse>
***************
*** 185,189 ****

  										<!--- Check to see if MEDIUMINT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "MEDIUMINT">
  											<option value="MEDIUMINT" selected class="Fancy">MEDIUMINT(m)</option>
  										<cfelse>
--- 183,187 ----

! 										<cfif alterSpec[i].colType IS "MEDIUMINT">
  											<option value="MEDIUMINT" selected class="Fancy">MEDIUMINT(m)</option>
  										<cfelse>
***************
*** 192,196 ****

  										<!--- Check to see if INT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "INT">
  											<option value="INT" selected class="Fancy">INT(m)</option>
  										<cfelse>
--- 190,194 ----

! 										<cfif alterSpec[i].colType IS "INT">
  											<option value="INT" selected class="Fancy">INT(m)</option>
  										<cfelse>
***************
*** 199,203 ****

  										<!--- Check to see if BIGINT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "BIGINT">
  											<option value="BIGINT" selected class="Fancy">BIGINT(m)</option>
  										<cfelse>
--- 197,201 ----

! 										<cfif alterSpec[i].colType IS "BIGINT">
  											<option value="BIGINT" selected class="Fancy">BIGINT(m)</option>
  										<cfelse>
***************
*** 206,210 ****

  										<!--- Check to see if FLOAT option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "FLOAT">
  											<option value="FLOAT" selected class="Fancy">FLOAT(m,d)</option>
  										<cfelse>
--- 204,208 ----

! 										<cfif alterSpec[i].colType IS "FLOAT">
  											<option value="FLOAT" selected class="Fancy">FLOAT(m,d)</option>
  										<cfelse>
***************
*** 213,217 ****

  										<!--- Check to see if DOUBLE option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "DOUBLE">
  											<option value="DOUBLE" selected class="Fancy">DOUBLE(m,d)</option>
  										<cfelse>
--- 211,215 ----

! 										<cfif alterSpec[i].colType IS "DOUBLE">
  											<option value="DOUBLE" selected class="Fancy">DOUBLE(m,d)</option>
  										<cfelse>
***************
*** 220,224 ****

  										<!--- Check to see if DECIMAL option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "DECIMAL">
  											<option value="DECIMAL" selected class="Fancy">DECIMAL(m,d)</option>
  										<cfelse>
--- 218,222 ----

  										<!--- 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>
***************
*** 228,232 ****
  									<optgroup label="Date Time" class="Fancy">
  										<!--- Check to see if DATE option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "DATE">
  											<option value="DATE" selected class="Fancy">DATE</option>
  										<cfelse>
--- 226,230 ----
  									<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>
***************
*** 235,239 ****

  										<!--- Check to see if TIME option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TIME">
  											<option value="TIME" selected class="Fancy">TIME</option>
  										<cfelse>
--- 233,237 ----

! 										<cfif alterSpec[i].colType IS "TIME">
  											<option value="TIME" selected class="Fancy">TIME</option>
  										<cfelse>
***************
*** 242,246 ****

  										<!--- Check to see if DATETIME option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "DATETIME">
  											<option value="DATETIME" selected class="Fancy">DATETIME</option>
  										<cfelse>
--- 240,244 ----

! 										<cfif alterSpec[i].colType IS "DATETIME">
  											<option value="DATETIME" selected class="Fancy">DATETIME</option>
  										<cfelse>
***************
*** 249,253 ****

  										<!--- Check to see if YEAR option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "YEAR">
  											<option value="YEAR" selected class="Fancy">YEAR</option>
  										<cfelse>
--- 247,251 ----

! 										<cfif alterSpec[i].colType IS "YEAR">
  											<option value="YEAR" selected class="Fancy">YEAR</option>
  										<cfelse>
***************
*** 256,260 ****

  										<!--- Check to see if TIMESTAMP option was selected, and reselect it accordingly --->
! 										<cfif Evaluate("FORM.fieldType#i#") IS "TIMESTAMP">
  											<option value="TIMESTAMP" selected class="Fancy">TIMESTAMP(m)</option>
  										<cfelse>
--- 254,258 ----

  										<!--- 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>
***************
*** 510,513 ****
--- 508,512 ----
  	</cfform>
  </cflock>
+ 