[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.13,1.14

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 755539 ] Added isTextOrBlobCol and isTemporalCol

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** alterTable.cfm	16 Jun 2003 20:36:45 -0000	1.13
--- alterTable.cfm	16 Jun 2003 21:06:43 -0000	1.14
***************
*** 72,78 ****
  						<cfset htmlSQL = "#htmlSQL# <span class=""Missing"">DataTypeNotSpecified_#i#</span>">
  					<cfelse>
! 						<!--- Initialize Integer and Numeric Type to FALSE --->
  						<cfset isIntegerCol = FALSE />
  						<cfset isNumericCol = FALSE />
  						<!--- Add Column Type to Output Strings --->
  						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#">
--- 72,80 ----
  						<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#">
***************
*** 138,142 ****
  								</cfif>
  							</cfcase>
! 							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
  						</cfswitch>
  						<!--- Add Unsigned to Output Strings if Specified and is Numeric Column --->
--- 140,151 ----
  								</cfif>
  							</cfcase>
! 							<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT">
! 								<!--- Set Text or Blob Type to TRUE --->
! 								<cfset isTextOrBlobCol = TRUE />
! 							</cfcase>
! 							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP">
! 								<!--- Set Temporal Type to TRUE --->
! 								<cfset isTemporalCol = TRUE />
! 							</cfcase>
  						</cfswitch>
  						<!--- Add Unsigned to Output Strings if Specified and is Numeric Column --->
***************
*** 159,163 ****
  						</cfif>
  						<!--- Add DEFAULT to Output Strings if Specified --->
! 						<cfif ATTRIBUTES.alterSpec[i].defaultValue IS NOT "">
  							<cfset rawSQL = "#rawSQL# DEFAULT #ATTRIBUTES.alterSpec[i].defaultValue#">
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">DEFAULT</span> <span class=""String"">#ATTRIBUTES.alterSpec[i].defaultValue#</span>">
--- 168,172 ----
  						</cfif>
  						<!--- Add DEFAULT to Output Strings if Specified --->
! 						<cfif ATTRIBUTES.alterSpec[i].defaultValue IS NOT "" AND NOT isTextOrBlobCol>
  							<cfset rawSQL = "#rawSQL# DEFAULT #ATTRIBUTES.alterSpec[i].defaultValue#">
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">DEFAULT</span> <span class=""String"">#ATTRIBUTES.alterSpec[i].defaultValue#</span>">