#val(draw)# #val(draw)# #val(draw)#

having iussue serializing the columns for datatables

66 Views Asked by At

I am getting my data from sql server adn i am having trouble when i am trying to send back a proper json format

{"draw": <cfoutput>#val(draw)#</cfoutput>,
"recordsTotal": <cfoutput>#recordsTotal#</cfoutput>,
"recordsFiltered": <cfoutput>#qFiltered.recordCount#</cfoutput>,
"data": [
<cfif qFiltered.recordcount gt 0>
<cfoutput query="qFiltered" startrow="#val(start+1)#" maxrows="#val(length)#">
    <cfif currentRow gt (start+1)>,</cfif>
        #Replace(SerializeJSON(qFiltered,'struct'),'\','','all')#,
</cfoutput> 
<cfelse>
    ""
</cfif>
]
}

someehow the code is ending in invalid nested data, not sure what i am doing wrong here

0

There are 0 best solutions below