Correcting row sequence

Correcting row sequence

jch92592jch92592 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

  • kthorngrenkthorngren Posts: 20,425Questions: 26Answers: 4,794

    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

  • jch92592jch92592 Posts: 2Questions: 1Answers: 0

    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

Sign In or Register to comment.