Search

In the database I'm reading from, I have a "status" column. Essentially it is storing a, open and closed option for a row. I have an image I want to use for the open status and for the closed status. Right now open = 1 in the database and closed = 2. I'm using a slightly modified version of the server scripting for php (http://datatables.net/development/server-side/php_mysql) I'm wondering how I would incorporate such a change when I'm using code like the above link shows. And the way you explain to me how to do this; would it affect searching in anyway? Because I will have another column that is item names, and in the column it actually displays the items image. Would the searching of the item be affected then?

Dear Sir, I am a Mechanical engineer with zero programming knowledge, can anyone suggest me how to have this done like this page for my data http://datatables.net/extras/tabletools/ I want filtered results to be made with search option dialog box . Data: http://jsfiddle.net/prabuk1985/rCChX/embedded/result/ http://jsfiddle.net/prabuk1985/rCChX/ Regards, prabu

Hi, I am very new to Data Tables. I am developing an application in Struts 1.2. I have seen an example in the web site for Server Side Processing at http://datatables.net/release-datatables/examples/data_sources/server_side.html I am having exactly same kind of requirement in my application. Can I get any such example written in Struts instead of PHP? Thanks in advance.

Dear all, can you help me to focus in in last row input element when dynamically add new row. Here is my code for new row [code] var addId = myTable.fnAddData([ '', 'elemtn2', 'element3']); var theNode = myTable.fnSettings().aoData[addId[0]].nTr; theNode.find('.item_name').focus() //not working [/code]

Hi All, I am very new at DataTables, and just recently installed it. I am using the COLDFUSION server-side processing version of the script. I would like to convert my RACE_DATE field from "0000-00-00 00:00:00" (YEAR, DAY, MONTH HOUR:MINS:SECOND) to "00/00/0000" or "00-00-0000" (MONTH, DAY, YEAR) format. I am using the following sAjaxSource code: [code] SELECT #listColumns# FROM #sTableName# WHERE OR #thisColumn# LIKE ORDER BY , #listGetAt(listColumns,(url["iSortCol_"&thisS]+1))# #url["sSortDir_"&thisS]# SELECT COUNT(#sIndexColumn#) as total FROM #sTableName# {"sEcho": #val(url.sEcho)#, "iTotalRecords": #qCount.total#, "iTotalDisplayRecords": #qFiltered.recordCount#, "aaData": [ , [,"-""#jsStringFormat(version)#""#jsStringFormat('' & qFiltered[thisColumn][qFiltered.currentRow] & '')#""#jsStringFormat('' & qFiltered[thisColumn][qFiltered.currentRow] & '')#""#jsStringFormat(qFiltered[thisColumn][qFiltered.currentRow])#"] ] } [/code] Please help... tried searching, which resulted in 5ish hours of nothing. I would deeply appreciated it! Thanks! Vic

I have gone through the column sorting in jQuery datatable and the various ways of controlling it.. I have a query is it possible to control sorting in such a way that clicking on upper arrow icon will do sorting in ascending order & down arrow icon will do sorting in descending order,when both the icons are visible at the same time??

Can anybody please tell me how to exclude a column in the Copy, Excel, Pdf option??? :-Abhishek

vertical scrolling is not working when i gave colspan to a raw .Is there any way to do that thanks

This seems strange: http://jsfiddle.net/y5d3b/ Some of the TD elements have empty DIV elements and it seems to be breaking the sorting. Is this expected behavior? Is there a way around it?

Hi, I am using check box to each of the row to select that row . And also having a checkbox in that column Header to select all the row which are displaying . If there is a 5 out of 10 records are displaying I need to select those 5 record only when i am clicking on Header checkbox and also check Box must get checked of those 5 records. If there is option in the script Please help me solve this issue . thanks in advance. Thanks & Regards , Thamaraiselvan