Basically your code is okay, thats the right way to do this. Anyhow, there are some misunderstandings:
-
fetchUserData.cfm does not contain key/value pairs. So it doesn’t make sense to address keys in mData. Just use
mData[index]
-
dataTables expects some more info from your serverside. At least you should tell datatables how many items in total are on your serverside and how many are filtered.
I just hardcoded this info to your data. You should get the right values from counts in your server sided script.{ "iTotalRecords":"6", "iTotalDisplayRecords":"6", "aaData": [ [ "1", "sameek", "sam", "sam", "[email protected]", "1", "" ],...
-
If you have the column names already set in the html part, you don’t need to add sTitle.
-
The mRender Function takes three parameters:
- data = The data for this cell, as defined in mData
- type = The datatype (can be ignored mostly)
- full = The full data array for this row.
So your mRender function should look like this:
"mRender": function(data, type, full) {
return '<a class="btn btn-info btn-sm" href=#/' + full[0] + '>' + 'Edit' + '</a>';
}
Find a working Plunker here