Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2009-05-08 10:44:48
- ceetee
- Member
- Registered: 2006-09-16
- Posts: 11
Sorting numbers
The numbers I want to sort are prices. I’ve got the Textpattern Solutions book and it says only alphabetical sorts are possible, and putting zeros in front wouldn’t look good. Is there any way around this? I’ll be using custom fields.
Offline
Re: Sorting numbers
You can sort using a MySQL function, something like:
<article sort="convert(custom_1, decimal) asc"/>(not tested)
Offline
#3 2009-05-08 18:26:50
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Sorting numbers
Would this post help?
Offline
#4 2009-05-08 18:39:57
- ceetee
- Member
- Registered: 2006-09-16
- Posts: 11
Re: Sorting numbers
Cheers Juanjo and Els. That looks like the answer.
Offline
Pages: 1