I am having problems getting this
particular evaluate function to work. The error message as well as the snippet of
code is below ;
An error occurred while evaluating the expression:
#Evaluate("Item" & ThisRow)#
Error near line 90, column
54.----------------------------------------------------------------------
----------
An error has occurred while processing the expression:
Item1
Error near line 1, column 1.
-------------------------------------------------------------------------
-------
Error resolving parameter ITEM1
Here is the code snippett below:
<cfset totalcost= 0>
<cfset foodtypes="Food,NonFood">
<cfloop from=1 to=2 index="thistype">
<cfloop FROM="1" TO="#MaxRows#" INDEX="ThisRow">
<cfquery name="getfoodtype" datasource="cookie1">
----this is where the error is occuring ----
SELECT TYPE FROM Final WHERE Final.ItemID
= ("ItemID" & ThisRow)#
</cfquery>
<cfif getfoodtype.type eq listgetat(foodtypes,
thistype)>
<tr>
<td class="tttext" nowrap><b>#getfoodtype.Type#</b> #Evaluate("Item"
&
ThisRow)#</td>
<td align="center" class="tttext">#Evaluate("QTY"
& ThisRow)#</td>
<td align="center" class="tttext"> </td>
<td align="center" class="tttext"> </td>
<td class="tttext">#LSCurrencyFormat(Evaluate("sub" & ThisRow))#</td>
</tr>
<cfset totalcost= Evaluate("sub" & ThisRow) + totalcost>
</cfif>
Any ideas?
Bruce
H. Sorge
|
