[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.23,1.24

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Internal Structure Changed:
[ 758157 ] Converted Some Code to <CFScript>

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** alterTable.cfm	26 Jun 2003 19:15:47 -0000	1.23
--- alterTable.cfm	27 Jun 2003 14:14:17 -0000	1.24
***************
*** 56,87 ****
  				<!--- "ADD COLUMN" Alter Specification --->
  				<cfcase value="ADD COLUMN">
! 					<!--- ADD COLUMN KeyWord --->
! 					<cfset rawSQL = "#rawSQL# ADD COLUMN" />
! 					<cfset htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD COLUMN</span>" />
  					
! 					<!--- Column Name --->
! 					<cfif ATTRIBUTES.alterSpec[i].colName IS "">
! 						<cfset rawSQL = "#rawSQL# NameNotSpecified_#i#" />
! 						<cfset htmlSQL = "#htmlSQL# <span class=""Missing"">NameNotSpecified_#i#</span>" />
! 					<cfelse>
! 						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colName#" />
! 						<cfset htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].colName#</span>" />
! 					</cfif>
  					
! 					<!--- Column Type --->
! 					<cfif ATTRIBUTES.alterSpec[i].colType IS "" OR ATTRIBUTES.alterSpec[i].colType IS "Empty">
! 						<cfset rawSQL = "#rawSQL# DataTypeNotSpecified_#i#" />
! 						<cfset htmlSQL = "#htmlSQL# <span class=""Missing"">DataTypeNotSpecified_#i#</span>" />
! 					<cfelse>
! 						<!--- Initialize Integer, Numeric, and isTextOrBlobCol Type to FALSE --->
! 						<cfset isIntegerCol = FALSE />
! 						<cfset isNumericCol = FALSE />
! 						<cfset isTextOrBlobCol = FALSE />
! 						<cfset isTemporalCol = FALSE />
! 						<!--- Add Column Type to Output Strings --->
! 						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#" />
! 						<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>" />
! 						<!--- Type Options --->
! 					<cfscript>
  						switch(ATTRIBUTES.alterSpec[i].colType){
  							case "VARCHAR": case "CHAR":{
--- 56,91 ----
  				<!--- "ADD COLUMN" Alter Specification --->
  				<cfcase value="ADD COLUMN">
! 				<cfscript>
! 					// ADD COLUMN KeyWord
! 					rawSQL = "#rawSQL# ADD COLUMN";
! 					htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD COLUMN</span>";
  					
! 					// Column Name
! 					if(ATTRIBUTES.alterSpec[i].colName IS ""){
! 						rawSQL = "#rawSQL# NameNotSpecified_#i#";
! 						htmlSQL = "#htmlSQL# <span class=""Missing"">NameNotSpecified_#i#</span>";
! 					}else{
! 						rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colName#";
! 						htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].colName#</span>";
! 					}
  					
! 					// Column Type
! 					if(ATTRIBUTES.alterSpec[i].colType IS "" OR ATTRIBUTES.alterSpec[i].colType IS "Empty"){
! 						rawSQL = "#rawSQL# DataTypeNotSpecified_#i#";
! 						htmlSQL = "#htmlSQL# <span class=""Missing"">DataTypeNotSpecified_#i#</span>";
! 					}else{
! 						// Initialize Integer, Numeric, isTextOrBlobCol, and Temporal Type to FALSE
! 						isIntegerCol = FALSE;
! 						isNumericCol = FALSE;
! 						isTextOrBlobCol = FALSE;
! 						isTemporalCol = FALSE;
! 						
! 						// Add Column Type to Output Strings
! 						rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#";
! 						htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>";
! 
! 						//-----------------
! 						// Add Type Options
! 						//-----------------
  						switch(ATTRIBUTES.alterSpec[i].colType){
  							case "VARCHAR": case "CHAR":{
***************
*** 167,173 ****
  							}
  						}
! 					</cfscript>
! 										
! 					<cfscript>
  						// Add Unsigned to Output Strings if Specified and is Numeric Column
  						if(ATTRIBUTES.alterSpec[i].unsigned AND isNumericCol){
--- 171,175 ----
  							}
  						}
! 
  						// Add Unsigned to Output Strings if Specified and is Numeric Column
  						if(ATTRIBUTES.alterSpec[i].unsigned AND isNumericCol){
***************
*** 206,213 ****
  // ToDo: 				[reference_definition]
  
! 						//-----------------------------------------------------
! 						// Location of new Field : [FIRST | AFTER column_name ]
! 						//-----------------------------------------------------
! 						
  						// If location is set to "Beginning" ...
  						if(ATTRIBUTES.alterSpec[i].colLocation IS "Beginning"){
--- 208,214 ----
  // ToDo: 				[reference_definition]
  
! 						/*----------------------------------------------------
! 						  Location of new Field : [FIRST | AFTER column_name ]
! 						  ----------------------------------------------------*/
  						// If location is set to "Beginning" ...
  						if(ATTRIBUTES.alterSpec[i].colLocation IS "Beginning"){
***************
*** 259,264 ****
  							}
  						}
! 					</cfscript>
! 					</cfif>
  				</cfcase>
  <!--- ToDo Cases: --->
--- 260,265 ----
  							}
  						}
! 					}
! 				</cfscript>
  				</cfcase>
  <!--- ToDo Cases: --->