8 Replies Latest reply on Nov 2, 2007 9:22 AM by Dan Bracuk

    Sorting an Array via Query

    Species_Evolution Level 1
      I'm trying to convert an array into a query in order to order it by different variables dependant on user selection.

      The code below is throwing the following error

      " The value "PAGE_HITS" cannot be converted to a number
      98 : <cfloop index="iArray" list="PAGE_HITS,PAGE_NAME">
      99 : <cfloop index="iCol" list="#ArrayLen(Pagehitsarray)#">
      100 : <cfset QuerySetCell(myQuery, iCol, Pagehitsarray[iArray][iCol], iArray)>
      101 :
      102 : </cfloop>

      I'm at a total loss - might be because it's Friday and my mind is wondering.....

      Thanks in advance.