[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.5,1.6

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 754236 ] Added Length and Decimals to 
REAL,FLOAT,DOUBLE,DECIMAL,NUMERIC field Types 

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** alterTable.cfm	13 Jun 2003 20:13:14 -0000	1.5
--- alterTable.cfm	13 Jun 2003 21:17:24 -0000	1.6
***************
*** 94,105 ****
  								--->
  							</cfcase>
! 							<cfcase value="FLOAT,DOUBLE,DECIMAL"></cfcase>
  							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP"></cfcase>
  								<!---
- 								  or    REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
- 								  or    DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
- 								  or    FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
- 								  or    DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
- 								  or    NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
  								  or    CHAR(length) [BINARY]
  								  or    VARCHAR(length) [BINARY]
--- 94,132 ----
  								--->
  							</cfcase>
! 							<cfcase value="REAL,FLOAT,DOUBLE">
! 								<!--- Add Length and Decimals to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].length IS NOT "">
! 									<cfset rawSQL = "#rawSQL#(#ATTRIBUTES.alterSpec[i].length#,#ATTRIBUTES.alterSpec[i].numberOfDecimals#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
! 								</cfif>
! 								<!--- 
! 										REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
! 										DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
! 										FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
! 								--->
! 							</cfcase>
! 							<cfcase value="DECIMAL,NUMERIC">
! 								<!--- Add Length to Output Strings --->
! 								<cfif ATTRIBUTES.alterSpec[i].length IS "" AND ATTRIBUTES.alterSpec[i].numberOfDecimals IS "">
! 									<cfset rawSQL = "#rawSQL#(LengthNotSpecified_#i#,DecimalsNotSpecified_#i#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Missing"">LengthNotSpecified_#i#</span>,<span class=""Missing"">DecimalsNotSpecified_#i#</span>)">
! 								<cfelseif ATTRIBUTES.alterSpec[i].length IS "">
! 									<cfset rawSQL = "#rawSQL#(LengthNotSpecified_#i#,#ATTRIBUTES.alterSpec[i].numberOfDecimals#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Missing"">LengthNotSpecified_#i#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
! 								<cfelseif ATTRIBUTES.alterSpec[i].numberOfDecimals IS "">
! 									<cfset rawSQL = "#rawSQL#(#ATTRIBUTES.alterSpec[i].length#,DecimalsNotSpecified_#i#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Missing"">DecimalsNotSpecified_#i#</span>)">
! 								<cfelse>
! 									<cfset rawSQL = "#rawSQL#(#ATTRIBUTES.alterSpec[i].length#,#ATTRIBUTES.alterSpec[i].numberOfDecimals#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
! 								</cfif>
! 
! 								<!---
! 										DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
! 										NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
! 								--->
! 							</cfcase>
  							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP"></cfcase>
  								<!---
  								  or    CHAR(length) [BINARY]
  								  or    VARCHAR(length) [BINARY]