RE: Evaluate Issues

[Johnny Thompson]

try..   <cfset varRow = "Item" & ThisRow> <cfset varRow = Evalute(varRow)> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sorge, Bruce Sent: Monday, November 26, 2001 8:09 AM To: 'List' Subject: Evaluate Issues 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