In such cases I would use Type01, Type02 in stead of Type1, Type2 Regards Johann
On 13 May 2013 02:07, rppowell <[email protected]> wrote: > Here is example code to show what I am doing. > > The following is in model/db.py: > > db.define_table('item_type', > Field('name'), > Field('description'), > format='%(name)s' > ) > > db.define_table('item', > Field('name'), > Field('description'), > Field('item_type'), > format='%(name)s' > ) > > db.item.item_type.requires = IS_IN_DB(db, db.item_type, '%(name)s', > orderby='name') > > # example fixtures > if db(db.item_type).isempty(): > db.item_type.insert(name='Type1') > db.item_type.insert(name='Type2') > db.item_type.insert(name='Type3') > db.item_type.insert(name='Type10') > db.item_type.insert(name='Type20') > db.item_type.insert(name='Type30') > db.item_type.insert(name='Type99') > > > I go to the appadmin/database administration page and under db.item I > click on the 'New Record' button. > In the form in the page ( > http://127.0.0.1:8000/naturalsort/appadmin/insert/db/item) , the drop > down displays the item_type as following: > > Type1 > Type10 > Type2 > Type20 > Type3 > Type99 > > > What do I put in the 'orderby' parameter to make the item type list like > the following: > > Type1 > Type2 > Type3 > Type10 > Type20 > Type30 > Type99 > > > > [Please use the above code to show in example what to do] > -rppowell > > > On Saturday, May 11, 2013 4:47:34 AM UTC-7, Niphlod wrote: >> >> IS_IN_DB accepts a "orderby" parameter..... > > -- > > --- > 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. > > > -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- 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.

