formfields.com Forum Index formfields.com
FORMfields Forums
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Data Doesn't Sort Properly

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> TH 2.0 - Frequently Asked Questions (FAQs)
View previous topic :: View next topic  
Author Message
formfields



Joined: 01 Aug 2005
Posts: 465

PostPosted: Mon Jan 23, 2006 5:11 pm    Post subject: Data Doesn't Sort Properly Reply with quote

Depending on the type of data that you try to sort on, the sorting feature may not work as intended. For example, sorting on a timestamp doesn't usually work in versions of MySQL before 5.0. This is due to the fact that MySQL sorts based on the ascii value of the timestamp instead of the actual value of the date. Another example would be sorting on a data where you insert HTML into your SQL query. At this point, there is no easy fix for this. Soon we will be releasing a new version of TableHelpers, which will allow you specify the details of how each column is to be sorted.
Back to top
View user's profile Send private message
sigurdur



Joined: 27 Jul 2006
Posts: 5

PostPosted: Tue Aug 08, 2006 10:41 am    Post subject: Reply with quote

Any news on this sorting business?

I'm using the BritishDateField trick to list dates as %d/%m/%Y, and as a result, the dates do not sort properly (i.e. they sort first by day, then month, then year, not year, month, day as they should). Any idea how to fix this?

Best regards,
Sigurdur
Back to top
View user's profile Send private message
formfields



Joined: 01 Aug 2005
Posts: 465

PostPosted: Mon Oct 02, 2006 10:01 pm    Post subject: Reply with quote

We are gearing up for a new FORMfields release, which will address this issue.
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> TH 2.0 - Frequently Asked Questions (FAQs) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group