1 Reply Latest reply on Mar 17, 2007 7:43 AM by kglad

    help query column

    bench
      i am connecting on a database via flash remoting, and i'd like to get the result of my query.

      on the clientside, my code is:

      trace(result.items[0].F1_1)

      this will return first item on the query with column name of F1_1

      however, i have a lot of columns returned and column names are named like F1_1, F1_2 ... F12_1, F12_12.... and so on and i'd like to get/trace the value of each column. My alternate solution to cut/save coding space is to do a loop:

      for(ctr1=1;ctr1<13;ctr1++){
      for(ctr2=1;ctr2<13;ctr2++){
      trace(this["result.items[0].F"+ctr1+"_"+ctr2])
      }
      }

      however the loop code returns undefined.
      any suggestion on how i am going to loop and return the value of the column names?