[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,1.11,1.12

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

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

Modified Files:
	AddField.cfm 
Log Message:
Functionality Added:
[ 757284 ] Added Key preselection logic (check or not checked) to 
all index types: 

<cfif #alterSpec[i].key# IS "???"> 
    <cfinput name="key#i#" type="radio" value="???" checked="yes" /> 
<cfelse> 
    <cfinput name="key#i#" type="radio" value="???" /> 
</cfif>

Index: AddField.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/AddField.cfm,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** AddField.cfm	13 Jun 2003 18:55:44 -0000	1.11
--- AddField.cfm	19 Jun 2003 15:00:35 -0000	1.12
***************
*** 459,477 ****
  							<!---||| Allow User to Specify a Single Column Index |||--->
  							<td>
! 								<cfinput name="key#i#" type="radio" value="Primary" /><label class="Fancy">Primary</label><br />
! 								<cfinput name="key#i#" type="radio" value="Unique" /><label class="Fancy">Unique</label><br />
  								<cfswitch expression="#alterSpec[i].colType#">
  									<cfcase value="TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,VARCHAR">
! 										<cfinput name="key#i#" type="radio" value="Fulltext" /><label class="Fancy">Fulltext</label><br />
  									</cfcase>
  								</cfswitch>
! 								<cfinput name="key#i#" type="radio" value="Index" /><label class="Fancy">Index</label>
  								<cfswitch expression="#alterSpec[i].colType#">
  									<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,CHAR,VARCHAR">
! 										Length()
  									</cfcase>
  								</cfswitch>
  								<br />
! 								<cfinput name="key#i#" type="radio" value="None" checked="yes" /><label class="Fancy">None</label>
  							</td>
  						</tr>
--- 459,506 ----
  							<!---||| Allow User to Specify a Single Column Index |||--->
  							<td>
! 								<!--- Primary Key --->
! 								<cfif #alterSpec[i].key# IS "Primary">
! 									<cfinput name="key#i#" type="radio" value="Primary" checked="yes" /><label class="Fancy">Primary</label><br />
! 								<cfelse>
! 									<cfinput name="key#i#" type="radio" value="Primary" /><label class="Fancy">Primary</label><br />
! 								</cfif>
! 								
! 								<!--- Unique Key --->
! 								<cfif #alterSpec[i].key# IS "Unique">
! 									<cfinput name="key#i#" type="radio" value="Unique" checked="yes" /><label class="Fancy">Unique</label><br />
! 								<cfelse>
! 									<cfinput name="key#i#" type="radio" value="Unique" /><label class="Fancy">Unique</label><br />
! 								</cfif>
! 								
! 								<!--- Fulltext Index --->
  								<cfswitch expression="#alterSpec[i].colType#">
  									<cfcase value="TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,VARCHAR">
! 										<cfif #alterSpec[i].key# IS "Fulltext">
! 											<cfinput name="key#i#" type="radio" value="Fulltext" checked="yes" /><label class="Fancy">Fulltext</label><br />
! 										<cfelse>
! 											<cfinput name="key#i#" type="radio" value="Fulltext" /><label class="Fancy">Fulltext</label><br />
! 										</cfif>
  									</cfcase>
  								</cfswitch>
! 								
! 								<!--- Plain Index --->
! 								<cfif #alterSpec[i].key# IS "Index">
! 									<cfinput name="key#i#" type="radio" value="Index" checked="yes" /><label class="Fancy">Index</label>
! 								<cfelse>
! 									<cfinput name="key#i#" type="radio" value="Index" /><label class="Fancy">Index</label>
! 								</cfif>
  								<cfswitch expression="#alterSpec[i].colType#">
  									<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,CHAR,VARCHAR">
! <!--- ToDo --->										Length()
  									</cfcase>
  								</cfswitch>
  								<br />
! 								
! 								<!--- No Key --->
! 								<cfif #alterSpec[i].key# IS "None">
! 									<cfinput name="key#i#" type="radio" value="None" checked="yes" /><label class="Fancy">None</label>
! 								<cfelse>
! 									<cfinput name="key#i#" type="radio" value="None" /><label class="Fancy">None</label>
! 								</cfif>
  							</td>
  						</tr>