db.define_table('Person',
Field('last_name', 'string'),
Field('name', 'string'),
Field('telephone', 'string'),
Field('email', 'string'),
Field('nationality','reference Nationalities',default=1),
format= '%(last_name)s,%(name)s '
)
default=the id of USA in Nationalities table
9 Şubat 2016 Salı 04:35:41 UTC+2 tarihinde Winter Kryz yazdı:
>
> Hello everybody,
>
> I am new in web2py, I have 2 tables called 'Nationalities' and 'Person'
>
> db.define_table('Nationalities',
> Field('description', 'string'),
> common_filter = lambda query:db.Nationalities.description
> != 'United States',
> format='%(description)s'
> )
>
> db.define_table('Person',
> Field('last_name', 'string'),
> Field('name', 'string'),
> Field('telephone', 'string'),
> Field('email', 'string'),
> Field('nationality','reference
> Nationalities',requires=IS_IN_DB(db(db.Nationalities.description),
> 'Nationalities.description', zero=T('United States'))),
> format= '%(last_name)s,%(name)s '
> )
> in 'Nationalities', I have listed all the countries of world and what I
> get is a dropdown list filled with them
> Now what I want to do is to display a particular country, let's say
> 'United States', at top to be ID 0 in my dropdownlist so when somebody
> fills the form the list shows 'United States' by default. I tried to do a
> query that shows all the countries except US in the list and then set 'US'
> as Zero but of course it didn't work because it says that the value that
> zero has it doesn't exist on the database.
> Please, I need some help because I'm stuck on this.
> Thanks!
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
