Search

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!!

short of encoding the data and having it decode in javascript, no. and anyone running your page will have access to the decoding key and/or algorithm, in which case it's not really secure either.

opss sorry i didn't see it. thanks :)

see my fix/comment: http://datatables.net/forums/discussion/6591/cleanup-fixedheader

Just send the unique URL in its own column, keep that column invisible, and use it for whatever you want with the fnRowCallback. You could add the anchor tag wrapping to any other column's content within the callback function instead of within the JSON itself. Be mindful of the limitations of markup itself. For example, foo is not valid. Which isn't to say you can't make the whole row clickable; just not with an anchor tag. But I'm getting ahead of myself: what is the specific use case?

http://datatables.net/release-datatables/examples/data_sources/ajax.html "DataTables expects an object with an array called "aaData" with the data source." This should fix your ajax/JSON: [code] { aaData: [ { "label":"9-hydroxy-risperidone", "x":0, "y":1.5051929155586775E-4, "z":"42.0", "cond":"treatment", "selected":0, "term":"9-hydroxy-risperidone", "star":0, "conceptId":"13697" }, ... (more data) [/code]