[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.22,1.23

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Internal Structure Changed:
[ 761376 ] Converted alterSpec[i].legalValues to an Array

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** alterTable.cfm	24 Jun 2003 21:38:11 -0000	1.22
--- alterTable.cfm	26 Jun 2003 19:15:47 -0000	1.23
***************
*** 38,43 ****
  		<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 |||--->
--- 38,41 ----
***************
*** 105,116 ****
  							case "ENUM": case "SET":{
  								// Add Legal Values to Output Strings
! 								if(ATTRIBUTES.alterSpec[i].legalValues IS ""){
  									rawSQL = "#rawSQL#(ValuesNotSpecified_#i#)";
  									htmlSQL = "#htmlSQL#(<span class=""Missing"">ValuesNotSpecified_#i#</span>)";
  								}else{
! 									// 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',...
! 									rawSQL = "#rawSQL#('#Replace(ATTRIBUTES.alterSpec[i].legalValues, "#CRLF#", "','", "ALL")#')";
! 									htmlSQL = "#htmlSQL#('<span class=""String"">#Replace(ATTRIBUTES.alterSpec[i].legalValues, "#CRLF#", "</span>','<span class=""String"">", "ALL")#</span>')";
  								}
  								break;
--- 103,114 ----
  							case "ENUM": case "SET":{
  								// Add Legal Values to Output Strings
! 								if(ArrayIsEmpty(ATTRIBUTES.alterSpec[i].legalValues)){
  									rawSQL = "#rawSQL#(ValuesNotSpecified_#i#)";
  									htmlSQL = "#htmlSQL#(<span class=""Missing"">ValuesNotSpecified_#i#</span>)";
  								}else{
! 									tempRawList = ArrayToList(ATTRIBUTES.alterSpec[i].legalValues, "','");
! 									tempHtmlList = ArrayToList(ATTRIBUTES.alterSpec[i].legalValues, "</span>','<span class=""String"">");
! 									rawSQL = "#rawSQL#('#tempRawList#')";
! 									htmlSQL = "#htmlSQL#('<span class=""String"">#tempHtmlList#</span>')";
  								}
  								break;