gistfile1.txt

function executeRecordSetObj(SQL){
    var conn = $.db.getConnection();
    var pstmt = conn.prepareStatement(SQL);
    var rs = pstmt.executeQuery();
    var rsm = rs.getMetaData();
    var strObj = '';
    
    while (rs.next()) {
        strObj += '{';
        for (var i = 1; i <= rsm.getColumnCount(); i++){
            strObj += '"' + rsm.getColumnName(i) + '":"' + rs.getString(i) + '",';
        }
        strObj = strObj.substring(0, strObj.length - 1);
        strObj += '},'
    }
    rs.close();
    pstmt.close();
    conn.close();
    
  return '[' + strObj.substring(0, strObj.length - 1) + ']';
}