ansaurus

Question

jquery DataTable - change value of a cell not just display value

Answer 1

A:

You should probably paste some more of your code, especially the sorting area.

It seems you're mixing up val() and html():

This will get you the input or cell value as in the value tag "value=?"

$("#currentRow").val()

This will get you the actual html (data) between the tag "<td>data</td>"

$("#currentRow").html()

Organiccat 2010-07-21 13:05:48

Hi there "fnRowCallback": function( nRow, aData, iDisplayIndex ) { if ( aData[2] == "0" ){ $('td:eq(1)', nRow).html( '2' ); nRow }else if ( aData[2] == "1" ){ $('td:eq(1)', nRow).html( '1' ); }else if ( aData[2] == "2" ){ $('td:eq(1)', nRow).html( '0' ); return nRow; },what i am trying to achieve is reversing the priority got from the server data (6 high priority - 0 low priority) for the purposes of sorting by priority so ascending (0 high - 6 low).many Thanks for your help

Shibbott 2010-07-21 13:22:55

After the fnRowCallback I do this sorting to try and sort by the revised Best Match (priority) "aaSorting": [[ 2, "asc" ]], "aoColumns": [ /*checkbox*/{ "bSortable": false }, /*ID*/{"bVisible": false }, /*best match*/null, /*VenueName*/null, /*Distance*/null, /*Capacity*/null, /*MeetingRooms*/null, /*Bedrooms*/null, /*Suitability*/null ]});

Shibbott 2010-07-21 13:26:25

Answer 2

A:

You need to update the datatable, not html.

oTable.fnUpdate( newValue, rowPos, columnPos);

assuming oTable is a reference to the datatable. See datatable docs for how to edit a row.

Yisroel 2010-07-21 13:34:40

Thanks I'll give it ago, I guess i need jeditable ti use fnUpdate, yeah?

Shibbott 2010-07-21 13:57:07

you should not need to use jEditable, just use fnUpdate. jEditable itself is not doing anything special other than calling fnUpdate in the example.

Yisroel 2010-07-21 13:59:38

ansaurus

tags:

views:

answers:

jquery DataTable - change value of a cell not just display value

related questions