search

rorx / redmine_wiki_sql

Redmine plugin that allows you to run SQL queries and have them shown on your wiki in table format
http://rodrigoramalho.com/redmine-wiki-sql-plugin/
11 stars 13 forks source link

Sorting seems to be broken #1

Closed modules closed 13 years ago

modules commented 13 years ago

Sorting seems to be broken. If i sort by id order ist 1,11,12,13,2,3,4,5, ... and not like expected 1,2,3,4,...,10,11,12.

rorx commented 13 years ago

I had the same problem here and solved it with MySQL's LPAD function: ORDER BY LPAD(field, 5, '0')