formfields.com

[formfields]

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.

[sigurdur]

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

[formfields]

We are gearing up for a new FORMfields release, which will address this issue.