2 Replies Latest reply on Aug 28, 2006 2:23 PM by Dan Bracuk

    Help with a query

    rottmanja Level 1
      I am working on a search system, that allows admins to return very specific data. The most important part of the search is returning a certain columns results as a list. The problem I have is this.

      When I run my test, I get an array of stuctures output like this.
      1
      struct
      ADDRESS 1222 W Baseline Road
      AGENTLIST Patrick Richardson
      COE 05/31/2005
      FILENUM S051990
      MLSNUM [empty string]
      PRICE 158875
      STATUS Closed
      2
      struct
      ADDRESS 1222 W Baseline Road
      AGENTLIST Jason Robinson
      COE 05/31/2005
      FILENUM S051990
      MLSNUM [empty string]
      PRICE 158875
      STATUS Closed

      But I need the returned output to look like this.
      1
      struct
      ADDRESS 1222 W Baseline Road
      AGENTLIST Patrick Richardson,Jason Robinson
      COE 05/31/2005
      FILENUM S051990
      MLSNUM [empty string]
      PRICE 158875
      STATUS Closed


      I have tried looping over the results and creating a list based on the returned objects from the query. But it only places the first record int he list and outputs that only.

      This is my current code that I am trying below. Can someone give me a hand with this?