Search

function (this is in order to prevent XSS attacks).

these select lists, in order to get all the

variables.index,',')# LIKE '%#form.sSearch#%' OR ) ORDER BY #listGetAt(variables.fieldlist,form["iSortCol_#variables.i#"]+1)# #form["sSortDir_#variables.i#"]# , { "sEcho":

it to 'true' in order to make it work.

some solutions: you can write your own custom sorting routine client side: use http://www.datatables.net/release-datatables/examples/plug-ins/sorting_sType.html serer side: alter the ORDER BY or even just change the format in SELECT queries you can render the column in another format: http://www.datatables.net/release-datatables/examples/advanced_init/column_render.html

needs a "kick" in order to set these in

name, then have your ORDER BY clause reflect this

they had the same order and count. From the

an in a different order from what DataTables expects)

are after this sort order aLengthMenu: [ 10, 25, 50,