Forum Discussion

Premier2k's avatar
Premier2k
Occasional Contributor
9 years ago

Looping through a resultset

Hi all,   I'm trying to loop through a result set and add the results to a map, I have done this already with some JSON output and I'm trying to do the same for the database resultset but it's only...
nmrao's avatar
nmrao
Champion Level 3
9 years ago
Can you show the sample response and which data you are trying to retrieve?
  • Premier2k's avatar
    Premier2k
    Occasional Contributor
    9 years ago

    Sure, I've attached the response I'm getting back from my DB call.

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      But this is not json in the first place.

      So what data you want ?
      • Premier2k's avatar
        Premier2k
        Occasional Contributor
        9 years ago

        Correct, the JSON output is being handled correctly, that is the gatewayMap. I'm trying to add the DB response to the stagingMap but it only outputs the first row

    • Premier2k's avatar
      Premier2k
      Occasional Contributor
      9 years ago

       

      This is my log output. The top line shows the correct output for gatewayMap, the second line shows what's coming out from the stagingMap. Seems to only be outputting the 1st row from the DB resultset rather than capturing each.