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

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

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

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

      <cfreturn qBrok>

      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?