QueryToJson

What you want is so close to the third result, it requires just a slight change in that code.

public string function queryToJSON()

{

var q = new Query();

var qResult = "";

var colList = "";

var l = 0;

var x = 0;

var i = 0;

var str=structNew();

var arr=arrayNew(1);

q.setdataSource("TestingDataSource");

q.setsql("SELECT * FROM Product");

qResult = q.execute().getresult();

colList = qResult.Columnlist;

l = ListLen(colList);

for(x=1;x LTE qResult.recordcount;x=x+1) // x is row number

{

   for (i = 1; i lte l; i = i + 1)  // you also can use i++ instead

   {

    columnName = listGetAt(colList,i);

    str[columnName]=qResult[columnName];

   }

    arr=str; // each row x is stored in the array arr as a struct

}

jsonString = SerializeJSON(arr);

return jsonString;

}

Query column names and structure key names are capitalized in CF and I that is just something you have to deal with. There is one exception with structures that I am aware of:

     <cfset variables.s.FieldName="abc" />

will be capitalized when using StructKeyList() whereas

     <cfset variables.s["FieldName"]="abc" />

will preserve the upper/lower case. I'm not aware of any such exception with query column names.

If I have full control of the end using the json data, I send the column names through LCase() and just deal with lower case names. Other than that, the only other option is to create a hard coded field name translater: PRODUCTID--> ProductId.

Hope this helps.