[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.16,1.17

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 756653 ] Added Legal Values to Output Strings for SET and ENUM 
column types 

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** alterTable.cfm	18 Jun 2003 13:33:33 -0000	1.16
--- alterTable.cfm	18 Jun 2003 15:11:29 -0000	1.17
***************
*** 35,40 ****
--- 35,43 ----
  		<!-------------------------------------------->
  		<!---||| Initialize Internal Variables |||--->
+ 		<!--- Output Strings --->
  		<cfset rawSQL = "ALTER TABLE" />
  		<cfset htmlSQL = "<span class=""KeyWord"">ALTER TABLE</span>" />
+ 		<!--- New Line Break: Carriage Return and Linefeed Characters used as delimiters --->
+ 		<cfset CRLF="#Chr(13)##Chr(10)#" />
  		
  		<!---||| Table Name |||--->
***************
*** 99,106 ****
  							</cfcase>
  							<cfcase value="ENUM,SET">
! <!--- TODO:
! 									ENUM(value1,value2,value3,...)
! 									SET(value1,value2,value3,...)
! 								--->
  							</cfcase>
  							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,INTEGER,BIGINT">
--- 102,115 ----
  							</cfcase>
  							<cfcase value="ENUM,SET">
! 								<!--- Add Legal Values to Output Strings --->
! 								<cfif ATTRIBUTES.alterSpec[i].legalValues IS "">
! 									<cfset rawSQL = "#rawSQL#(ValuesNotSpecified_#i#)" />
! 									<cfset htmlSQL = "#htmlSQL#(<span class=""Missing"">ValuesNotSpecified_#i#</span>)" />
! 								<cfelse>
! 									<!--- Replace the Carriage Return and Linefeed Characters with a single quote, comma, and a single quote--->
! 									<!--- Also add begining and trailing single quotes so the value list is in the correct format: 'value1','value2',... --->
! 									<cfset rawSQL = "#rawSQL#('#Replace(ATTRIBUTES.alterSpec[i].legalValues, "#CRLF#", "','", "ALL")#')" />
! 									<cfset htmlSQL = "#htmlSQL#('<span class=""String"">#Replace(ATTRIBUTES.alterSpec[i].legalValues, "#CRLF#", "</span>','<span class=""String"">", "ALL")#</span>')" />
! 								</cfif>
  							</cfcase>
  							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,INTEGER,BIGINT">