Thread

Hello,

I have a weblog with a field called Order, in there i order all my entries with number.

For Example:

John Lennon 1
Paul McCartney 2
Gorge Harrison 3
Ringo Star 4
Elvis Presley 5

So, in this way i set my weblog to orderby=“order” sort=“asc” to appear as the list.

But what happened when i pass number 9 the list is:

John Lennon 1
Mick Jagger 10
Kurt Cobain 11
Paul McCartney 2
Gorge Harrison 3
Ringo Star 4
Elvis Presley 5

I understand what happened is that EE call all the 1 at first but is there any way to set up to bring in order this numbers?

The simples way is to use 01, 02, 03 ... 09, 10, 11 etc.

Thank you Ingmar, will edit it..

Cool. This is not an EE issue as such, it’s got to do with database collation. Any other solution would require modifying the db directly, and we don’t recommend (or support) that if it can be helped 😊 Please post again as needed.