Search

aoColumnDef structure: [code] var colsdef = [ { "fnRender": function (o, val) { return "" + o.aData["col1"] + ""; }, "bUseRendered": false, "aTargets": [0] }, { "fnRender": function (o, val) { return "" + o.aData["col3"] + ""; }, "bUseRendered": false, "aTargets": [2] }, { "fnRender": function (o, val) { return "" + o.aData['col6'] + ""; }, "bUseRendered": false, "aTargets": [4] }, { "fnRender": function (o, val) { return "" + o.aData['col9'] + ""; }, "aTargets": [9] }, { "fnRender" : function (o, val) { return "" + o.aData['col10'] + ""; }, "bUseRendered": false, "aTargets" : [10] }, { "fnRender" : function (o, val) { return "" + o.aData['col14'] + ""; }, "bUseRendered": false, "aTargets": [14] }, { "fnRender": function (o, val) { return "" + o.aData['col15'] + ""; }, "bUseRendered": false, "aTargets": [15] }, { "fnRender": function (o, val) { return "" + o.aData['col16'] + ""; }, "bUseRendered": false, "aTargets": [16] }, { "fnRender": function (o, val) { return "" + o.aData['col17'] + ""; }, "bUseRendered": false, "aTargets": [17] }, { "fnRender": function (o, val) { return "" + o.aData['col18'] + ""; }, "bUseRendered": false, "aTargets": [18] }, { "fnRender": function (o, val) { return "" + o.aData['col19'] + ""; }, "bUseRendered": false, "aTargets": [19] }, { "fnRender": function (o, val) { return " View Add " + o.aData['daysSinceLastReview'] + " "; }, "bUseRendered": false, "aTargets": [27] } ] [/code] -- See Part 3

First, thanks for ur help. I'm new here and thanks for the great tool dataTables. This is my config about my problem [code] $('a#calculate').bind('click',function(){ $('#example').dataTable({ "bProcessing": true, "bDestroy": true, "bServerSide": true, "sAjaxSource": "/_calc_netflow", "fnServerData": function ( sSource, aoData, fnCallback ) { aoData.push({ 'choice':$('#choice').val(), 'start':$('#start').val(), 'end':$('#end').val() }) $.getJSON(sSource,aoData,fnCallback) } }); }); [/code] when i use it , i get error in my server-side: [code] 192.168.108.13 - - [21/May/2012 14:01:21] "GET /_calc_netflow? sEcho=1&iColumns=3&sColumns=&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&mDataProp_1=1 &mDataProp_2=2&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1= &bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&iSortCol_0=0& sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&undefined=undefined HTTP/1.1" [/code] i search whole this side but i couldn't find answer. Does any here help me?

-- Edited -- Reason : Found it on some external website.

Hi, this is my first post. Great plugin, by the way. I am using the DataTables.net v.1.9 and the latest version for JQuery. I am actually loading the page with the table and it works fine. Now the problem is that I would like to recreate the table using a table coming from a PHP file (the actual content result is the HTML table). I'm using: $(".tableclass").load("url") in order to get the html table. After this step, I recreate the table and i replace the previous table with the new one doing a second call of datatable(options). First I got a warning message about the table can't be initialized and the message suggests to see documentation for bRetrieve or bDestroy. Than I set them true and the table is replaced correctly when i click on the trigger button, but all the plugin features are not applied to the table. Before I go on, can anyone please tell me if my goal can be achieved using Datatables or not? Thanks

I have a PHP script which is returning the aaData and aaColumns data to create a table, with the specified titles. Using the code below I get an error that oColumn is undefined (with a blank table): [code] $('#example').dataTable( { "bProcessing": true, "sAjaxSource": 'script.php' } ); [/code] As a workaround, I am instead successfully using: [code] $.getJSON('script.php', {}, function(data) { $('#example').dataTable( data ); }); [/code] Is there a reason why the JSON call can't accept a list of columns in the same format as a direct call? Or is there a different format that's preferred for specifying table columns in the JSON object? If not, I humbly suggest adding this as an option in the next release.

Hi There. I am having an issue with this sorting the following. It loads everything fine and sorts by the correct column, however, it's ascending. I would like to have it sort on load descending but am not sure how to do so. Any advice would be greatly appreciated. Thanks Derrick $('#myTable').dataTable({ "bProcessing": true, "bAutoWidth": false, "bJQueryUI": true, "sAjaxSource": "/path/to/service/", "aoColumns": [ { "mDataProp": "LabNumber", "sType": "string"}, { "mDataProp": "DateClosed" }, { "mDataProp": "ConsumerName" }, { "mDataProp": "Status" }, ] });

Hi, I'm wondering if it is possible to use a separate call when the user clicks on the detailed information icon of a row. I'd like to present details for that selected row which are not in any hidden columns but can be generated a server-side script. I just need help to set up the client side function which will call the server side php. Thanks, Peter

I'm using following code in ASP.NET MVC Application. If first time five records render then on every next request records five duplicate records will add. How can I solve this problem? $('#tableStandardResults').dataTable({ "sPaginationType": "full_numbers", "bFilter": false, "bDestroy": false });

Hello! I have an issue with the columns width. I need several columns with the fixed width, so I use following config: [code] $('#table-users').dataTable({ "bProcessing": true, "sDom": 'T<"clear">"<"top"lf<"clear">>rt<"block-actions"ip>"', "sAjaxSource": '/admin/get_users_list', "bAutoWidth": false, "sScrollX": "100%", "oTableTools": { ........ }, "aaSorting": [], "aoColumnDefs": [ { "sWidth" : "200px", "aTargets": [ 17 ] } ] }); [/code] When the page is loaded the width of the 17th column is equal to "200px", but when data is loaded, width recalculation occurs and the 17th column becomes shorter. Could anyone help with this issue ? Best regards, Andrey

Hello Allan and all, I have seen this problem in the forums but didn't see an answer. When I run my PhP script under firebug, I get the following error: [quote] oColumn.asSorting is undefined oSettings.aaSorting[i][1] = oColumn.asSorting[0]; [/quote] my table initialization is as follows: [code] $(document).ready(function() { $('#example').dataTable( { "bProcessing": true, "bServerSide": false, "sAjaxSource": "get_table_info.php", "fnServerParams": function ( aoData ) { aoData.push( { "name": "more_data", "value": "my_value" } ); } } ); } ); [/code] I am trying to dynamically create a table by passing its name from a select (drop-down) box and I see that the script is properly getting the table name. Is this possible using datatables? I populate the select box using mysql (show tables) and build the column list using mysql (describe table) on the selected table name. All suggestions will be greatly appreciated!