[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.23,1.24
Status: Alpha
Brought to you by:
nanoface
|
From: <nan...@us...> - 2003-06-27 14:14:23
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv22607/Query
Modified Files:
alterTable.cfm
Log Message:
Internal Structure Changed:
[ 758157 ] Converted Some Code to <CFScript>
Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** alterTable.cfm 26 Jun 2003 19:15:47 -0000 1.23
--- alterTable.cfm 27 Jun 2003 14:14:17 -0000 1.24
***************
*** 56,87 ****
<!--- "ADD COLUMN" Alter Specification --->
<cfcase value="ADD COLUMN">
! <!--- ADD COLUMN KeyWord --->
! <cfset rawSQL = "#rawSQL# ADD COLUMN" />
! <cfset htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD COLUMN</span>" />
! <!--- Column Name --->
! <cfif ATTRIBUTES.alterSpec[i].colName IS "">
! <cfset rawSQL = "#rawSQL# NameNotSpecified_#i#" />
! <cfset htmlSQL = "#htmlSQL# <span class=""Missing"">NameNotSpecified_#i#</span>" />
! <cfelse>
! <cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colName#" />
! <cfset htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].colName#</span>" />
! </cfif>
! <!--- Column Type --->
! <cfif ATTRIBUTES.alterSpec[i].colType IS "" OR ATTRIBUTES.alterSpec[i].colType IS "Empty">
! <cfset rawSQL = "#rawSQL# DataTypeNotSpecified_#i#" />
! <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#" />
! <cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>" />
! <!--- Type Options --->
! <cfscript>
switch(ATTRIBUTES.alterSpec[i].colType){
case "VARCHAR": case "CHAR":{
--- 56,91 ----
<!--- "ADD COLUMN" Alter Specification --->
<cfcase value="ADD COLUMN">
! <cfscript>
! // ADD COLUMN KeyWord
! rawSQL = "#rawSQL# ADD COLUMN";
! htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD COLUMN</span>";
! // Column Name
! if(ATTRIBUTES.alterSpec[i].colName IS ""){
! rawSQL = "#rawSQL# NameNotSpecified_#i#";
! htmlSQL = "#htmlSQL# <span class=""Missing"">NameNotSpecified_#i#</span>";
! }else{
! rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colName#";
! htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].colName#</span>";
! }
! // Column Type
! if(ATTRIBUTES.alterSpec[i].colType IS "" OR ATTRIBUTES.alterSpec[i].colType IS "Empty"){
! rawSQL = "#rawSQL# DataTypeNotSpecified_#i#";
! htmlSQL = "#htmlSQL# <span class=""Missing"">DataTypeNotSpecified_#i#</span>";
! }else{
! // Initialize Integer, Numeric, isTextOrBlobCol, and Temporal Type to FALSE
! isIntegerCol = FALSE;
! isNumericCol = FALSE;
! isTextOrBlobCol = FALSE;
! isTemporalCol = FALSE;
!
! // Add Column Type to Output Strings
! rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#";
! htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>";
!
! //-----------------
! // Add Type Options
! //-----------------
switch(ATTRIBUTES.alterSpec[i].colType){
case "VARCHAR": case "CHAR":{
***************
*** 167,173 ****
}
}
! </cfscript>
!
! <cfscript>
// Add Unsigned to Output Strings if Specified and is Numeric Column
if(ATTRIBUTES.alterSpec[i].unsigned AND isNumericCol){
--- 171,175 ----
}
}
!
// Add Unsigned to Output Strings if Specified and is Numeric Column
if(ATTRIBUTES.alterSpec[i].unsigned AND isNumericCol){
***************
*** 206,213 ****
// ToDo: [reference_definition]
! //-----------------------------------------------------
! // Location of new Field : [FIRST | AFTER column_name ]
! //-----------------------------------------------------
!
// If location is set to "Beginning" ...
if(ATTRIBUTES.alterSpec[i].colLocation IS "Beginning"){
--- 208,214 ----
// ToDo: [reference_definition]
! /*----------------------------------------------------
! Location of new Field : [FIRST | AFTER column_name ]
! ----------------------------------------------------*/
// If location is set to "Beginning" ...
if(ATTRIBUTES.alterSpec[i].colLocation IS "Beginning"){
***************
*** 259,264 ****
}
}
! </cfscript>
! </cfif>
</cfcase>
<!--- ToDo Cases: --->
--- 260,265 ----
}
}
! }
! </cfscript>
</cfcase>
<!--- ToDo Cases: --->
|