this can only happen in sqlite if you changed the Field from string to
integer. If you delete the db and let web2py recreate it, it will work ok.
On Friday, March 1, 2013 9:33:05 AM UTC+1, St. Pirsch wrote:
>
>
> Hi,
> I'am trying to show my entries in an manually defined order.
>
> I choose 'integer' as field type: *db*.define_table('image',
> Field('Position', 'integer', label=T('Position')),
> In my controller, I use "*orderby*" to sort the entries: *images* =*db*().
> *select*(*db.image.ALL*, *orderby*=*db.image.Position*)
>
> Instead of the desired order: 1, 2, 3, 12, 13 I get: 1, 12, 13, 2, 3
> I
> guess, this issue deals with date type, but I couldn't figure it out.
> thx,
> Stephan
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.