1 Reply Latest reply on Jan 9, 2007 7:04 AM by M. Huisman

    How to populate column of a datagrid from a query

    Like2Flex Level 1
      Hello,

      I want to know how to populate each column of the first row of my datagrid from a query.
      My query is as such :

      <cfcomponent>
      <cffunction name="getBrok" access="remote" returntype="query">

      <cfquery name="qBrok" datasource="mydb">
      select
      distinct brok
      from tbl_brok
      </cfquery>

      <cfreturn qBrok>
      </cffunction>
      </cfcomponent>

      I have 5 (can have more) records in tbl_brok, so if i have 5 values, each colulmn of the first row should show 1 value. see below.

      Brok A | B | C | D | E


      Anyone can tell me how to do this?

      Thx