renderData returning data in different way

17 views
Skip to first unread message

CyberBeep m

unread,
Jun 21, 2016, 10:21:23 AM6/21/16
to ColdBox Platform
{"query":{"ROWCOUNT":4,"COLUMNS":["TYPEID","TYPE"],"DATA":{"TYPEID":[1,2,3,4],"TYPE":["Program Office","SDM","Non Technical","Technical"]}},"totalcount":4}

same code in xml returns which looks fine.
<?xml version="1.0" encoding="UTF-8"?>
<struct>
   <query>
      <query rowCount="4" fieldNames="type,typeID">
         <row>
            <type>Program Office</type>
            <typeid>1</typeid>
         </row>
         <row>
            <type>SDM</type>
            <typeid>2</typeid>
         </row>
         <row>
            <type>Non Technical</type>
            <typeid>3</typeid>
         </row>
         <row>
            <type>Technical</type>
            <typeid>4</typeid>
         </row>
      </query>
   </query>
   <totalcount>4</totalcount>
</struct>

Just not sure what is the problem that json is not returning 4 rows.
Any help would be appreciated.
Reply all
Reply to author
Forward
0 new messages