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

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 754207 ] Added Length to Integer Column Types
in alterTable.cfm Query 

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** alterTable.cfm	13 Jun 2003 15:10:12 -0000	1.4
--- alterTable.cfm	13 Jun 2003 20:13:14 -0000	1.5
***************
*** 79,93 ****
  							<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT"></cfcase>
  							<cfcase value="ENUM,SET"></cfcase>
! 							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,BIGINT"></cfcase>
  							<cfcase value="FLOAT,DOUBLE,DECIMAL"></cfcase>
  							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP"></cfcase>
- 							
  								<!---
- 								  TINYINT[(length)] [UNSIGNED] [ZEROFILL]
- 								  or    SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
- 								  or    MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
- 								  or    INT[(length)] [UNSIGNED] [ZEROFILL]
- 								  or    INTEGER[(length)] [UNSIGNED] [ZEROFILL]
- 								  or    BIGINT[(length)] [UNSIGNED] [ZEROFILL]
  								  or    REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
  								  or    DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
--- 79,100 ----
  							<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT"></cfcase>
  							<cfcase value="ENUM,SET"></cfcase>
! 							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,INTEGER,BIGINT">
! 								<!--- Add Length to Output Strings if Specified --->
! 								<cfif ATTRIBUTES.alterSpec[i].length IS NOT "">
! 									<cfset rawSQL = "#rawSQL#(#ATTRIBUTES.alterSpec[i].length#)">
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
! 								</cfif>
! 								<!---
! 										TINYINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		INT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		INTEGER[(length)] [UNSIGNED] [ZEROFILL]
! 								  		BIGINT[(length)] [UNSIGNED] [ZEROFILL]
! 								--->
! 							</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]