Search

Great thank you very much! I really think that the examples on fnRender reference should be updated ;) Regards, Jimmy Rivera

Change "sSortDataType" for your "orderstatus" to "sType". Its a bit confusing I know, but sSortDataType is not actually what you where here. If that doesn't solve it, could you run your table through the DataTables debugger ( http://debug.datatables.net ) and let me know what the debug code is. Allan

Sorry! Problem solved, I was using an older version of datatables that did not allow for an array of objects to be passed as its datasource

Here is my JSON. This leaves the table stuck at "Processing. {"sEcho":0,"iTotalRecords":"0","iTotalDisplayRecords":"0","aaData":[]}. If I modify it to this: {"sEcho":0,"iTotalRecords":"0","iTotalDisplayRecords":"0","aaData":[{}]} The table columns are defined using mDataProp: fieldName, so the table is expecting objects, so it will try to parse the empty list of objects, complains that it couldn't find one of the named columns, then adds an empty row.

Gotcha. So just to clarify, themeroller does none of the styling of the data rows on this page? http://datatables.net/styling/themes/smoothness Thanks!

Wow! Works great! Thank you))

I tried an alternate approach, I thought of nuking the table every time I refresh the data and create a new one from scratch. There are two scenarios here, 1) If I don't alter the table data at all, then refresh works fine. 2) If I modify a column's data and then do a refresh I see an error message in the error console saying "$('#myTable').dataTables is not a function". For modifying the column data, this is what I do - [code] var $trNode = $(obj).parent().parent(); // obj is a button inside the td var aData = myTable.fnGetData(obj.parentNode.parentNode); var htmlStr = "Cancelled"; aData.status = htmlStr; $trNode.find("td:nth-child(3)").html(htmlStr); [/code]

thx fbas. That's a start. I'm still trying to figure out what will be the right path to follow. btw, in your code, line 24, you should prefer the following selector: $('>td',nRow) in order to have only the dataTable TD, not the ones that may be in the cell (as I have ;)) thx very much for ur help

OK I have resolved the problem...ran the code under firefox/firebug and it pinpointed a json error. I had a script include pointing to an old copy of json, removing the include defaulted to the proper version. Had to learn firebug (not too bad) to get it!

This was awesome thanks!! the code: [code] // this is where I added in my custom vars oSettings.aoData.push( { "name": "filter_date", "value": $('#filter_date').val() }, { "name": "filter_categories", "value": $('#filter_categories').val() } ); [/code] was what I was missing.. and couldn't figure out how to put in new parameters when I refreshed the table. I figure a funtion like oSettings.fnRowCallback would exist to repopulate the parameters. But whatever I'll take this. So now I just run: [code] var oSettings = datatablevariable.fnSettings(); oSettings.aoData.push( { "name": "SD", "value": sStartDate }, { "name": "UID", "value": iUserID } ); datatablevariable.fnReloadAjax(); datatablevariable.fnDraw(); [/code] and it works perfectly.. ugh this was killing me for 2 days.. thanks!!