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;
|
