Search

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

Hi As the Title suggests i need to find out if sort function is enabled will datatables support checkbox generated from Struts 2 tag more specifically from Iterator can u give me an example which i can refer

I just got back to my DataTables editor project and still have some work to do to figure out how the JSON for joined tables is made and especially used. Is duplication of these rows required? (two copies of "Printer" value) [code] "access":[ { "value":"1", "0":"1", "label":"Printer", "1":"Printer" } ] [/code] Or here: ("Printer" and a numeric id, same as above) Should mData be used to read from the above object here instead of repeating it? [code] { "DT_RowId": "row_8", "first_name": "Bryar", "last_name": "Long", "dept": { "id": "1", "name": "IT" }, "access": [ { "id": "1", "name": "Printer" } ], "extra": { } }, [/code] I find duplication inherently confusing. What happens if "label":"Printer" is changed to "label":"snarfblat", for example? There are still other copies with the text, "Printer". Where is the "label" key from the "access" object (the one at the top of this post) used? Sorry, I'm having a really hard time with this. As I mentioned in a previous post, I don't use PHP so have to generate the JSON manually.

Hi, I am new to datatable. I will be thankful if somebody help me reqarding the below request. Problem : There is a requirement in which i needs to display the certain data in a cell of a row in different colour so that when user do the sorting or filtering of that coloumn the colour coading will be visible and make Row of data standout. Thanks for your quick response.

see: http://property2.webbox.co.za/template/velocityOnly,DataTables.vm print button works, but none of the others do. would very much appreciate someone telling me what i'm doing wrong. http://debug.datatables.net/awesev thanks in advance