Correcting row sequence
Correcting row sequence
jch92592
Posts: 2Questions: 1Answers: 0
This is a GREAT plugin and has awesome potential for use in our applications.
No test case available as content behind company firewall.
No error messages
Issue: The DataTable instance is showing row numbers out of sequence as in top image attached.
The bottom image is the same table with the table id removed so the jQuery is not run.
How best to correct this?
Thank you.
John Houston
Temecula, CA USA
Answers
Sounds like that column is being sorted as a string. Datatables does automatic type detection. If the data is all numeric then it should detect as numeric and sort the numbers. Is there something other than numbers in that column? Null or empty data will result in the column sorted as a string.
Kevin
Thank you for the quick reply.
I was thinking the same - the sort column was being treated as a string not numeric.
The column is row number output from a ColdFusion (CF) query.
I was able to resolve the issue by creating a new page and using the same CF query.
I will work on my previous errant page at a later date.
Thanks again for the the reply and the great plugin.
John