Hello, everyone.
Can anyone help me rewrite this so that it does NOT use "Evaluate()"?
Thanks,Code:<!--- This first cfinvoke gets the data for a particular project ---> <cfinvoke component="components.getProjectInfo" method="getProjectInfo" returnvariable="appinfo" id="#getToken(ucase(trim(local.thisProj)),1,'|')#" table="#getToken(ucase(trim(local.thisProj)),2,'|')#"> <!--- This next cfinvoke gets the column names and associated datatype for each column of the table from the first cfinvoke ---> <cfinvoke component="components.getProjectInfo" method="getColumnInfo" returnvariable="columnInfo" table="#getToken(ucase(trim(local.thisProj)),2,'|')#"> <cfoutput query="columnInfo"><!--- appinfo.#columnInfo.COLUMN_NAME# - #Evaluate("appinfo.#columnInfo.COLUMN_NAME#")# (LENGTH:#Evaluate("len(appinfo.#columnInfo.COLUMN_NAME#)")#) <br /> ---> <cfswitch expression="#lcase(trim(columnInfo.DATA_TYPE))#"> <cfcase value="bigint,decimal,int,float,money,numeric,smallint,smallmoney,tinyint"> <cfif Evaluate("len(appinfo.#columnInfo.COLUMN_NAME#) eq 0") OR Evaluate("isNull(appinfo.#columnInfo.COLUMN_NAME#)")><cfset "appinfo.#columnInfo.COLUMN_NAME#" = 0></cfif> </cfcase> <cfcase value="char,nchar,varchar,nvarchar,text,ntext,real,xml"> <cfif Evaluate("len(appinfo.#columnInfo.COLUMN_NAME#) eq 0") OR Evaluate("isNull(appinfo.#columnInfo.COLUMN_NAME#)")><cfset "appinfo.#columnInfo.COLUMN_NAME#" = ""></cfif> </cfcase> <cfcase value="datetime,smalldatetime,timestamp"> <cfif Evaluate("len(appinfo.#columnInfo.COLUMN_NAME#) eq 0") OR Evaluate("isNull(appinfo.#columnInfo.COLUMN_NAME#)")><cfset "appinfo.#columnInfo.COLUMN_NAME#" = CreateODBCDateTime(now())></cfif> </cfcase> </cfswitch><!--- appinfo.#columnInfo.COLUMN_NAME# - #Evaluate("appinfo.#columnInfo.COLUMN_NAME#")#<br /><br /> ---> </cfoutput>


Reply With Quote

Bookmarks