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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to