OK,
I figured out my last problem. I passed the list in the URL rather than
in an array from one window to another. However, I am now having this
issue.
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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
