[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.9,1.10

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 755404 ] Added Unsigned, Zerofill to Numeric Column Types

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** alterTable.cfm	16 Jun 2003 15:10:16 -0000	1.9
--- alterTable.cfm	16 Jun 2003 15:51:59 -0000	1.10
***************
*** 103,109 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
! 								--->
  							</cfcase>
  							<cfcase value="REAL,FLOAT,DOUBLE">
--- 103,116 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
! 								<!--- Add Unsigned to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
! 									<cfset rawSQL = "#rawSQL# UNSIGNED">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
! 								</cfif>
! 								<!--- Add Zerofill to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
! 									<cfset rawSQL = "#rawSQL# ZEROFILL">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
! 								</cfif>
  							</cfcase>
  							<cfcase value="REAL,FLOAT,DOUBLE">
***************
*** 113,119 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
! 								--->
  							</cfcase>
  							<cfcase value="DECIMAL,NUMERIC">
--- 120,133 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! 								<!--- Add Unsigned to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
! 									<cfset rawSQL = "#rawSQL# UNSIGNED">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
! 								</cfif>
! 								<!--- Add Zerofill to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
! 									<cfset rawSQL = "#rawSQL# ZEROFILL">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
! 								</cfif>
  							</cfcase>
  							<cfcase value="DECIMAL,NUMERIC">
***************
*** 132,139 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! 
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
! 								--->
  							</cfcase>
  							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
--- 146,159 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! 								<!--- Add Unsigned to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
! 									<cfset rawSQL = "#rawSQL# UNSIGNED">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
! 								</cfif>
! 								<!--- Add Zerofill to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
! 									<cfset rawSQL = "#rawSQL# ZEROFILL">
! 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
! 								</cfif>
  							</cfcase>
  							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
***************
*** 141,145 ****
  					</cfif>
  				</cfcase>
! 				<!--- ToDo Cases: --->
  				<cfcase value="ADD INDEX"></cfcase>
  				<cfcase value="ADD PRIMARY KEY"></cfcase>
--- 161,165 ----
  					</cfif>
  				</cfcase>
! <!--- ToDo Cases: --->
  				<cfcase value="ADD INDEX"></cfcase>
  				<cfcase value="ADD PRIMARY KEY"></cfcase>