Welcome Guest, Not a member yet? Register   Sign In
jQuery Datatables API with CI4
#3

(This post was last modified: 02-08-2020, 12:21 PM by monkenWu.)

(02-08-2020, 11:31 AM)jreklund Wrote: Hi, just tried the examples on your website. The first one dosen't sort at all. The second are sorting like this:
title1
title10
title11
title2

instead of
title1
title2
...
title10
title11

Hi, maybe my example case is not well designed. Involving the fields of a varchar structure in sorting can cause this problem.
When the sort button is operated, the following query is generated:

SELECT *
FROM `news`
ORDER BY `title` ASC

Actually this query on the database(mysql db) will have the same result.
The sorting of the first example has no effect, because the sorting function is not demonstrated in this example, so the sorting function is not activated.
I will modify the example.
Reply


Messages In This Thread
jQuery Datatables API with CI4 - by monkenWu - 02-08-2020, 11:23 AM
RE: jQuery Datatables API plugin based CI4 - by monkenWu - 02-08-2020, 11:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB