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.


Reply via email to