db.provider.State.requires=IS_IN_DB(db,'states.State','%(State)s')
Massimo
On Apr 15, 2:59 pm, JohnMc <maruadventu...@gmail.com> wrote:
> I have a similar situation to that of Mr. Jeppesen. Here is the setup
> --
>
> db.define_table('states',
> SQLField('State','string',length=2)
>
> )
>
> db.define_table('provider',
> ...
> ...
> SQLField('State',db.states),
> ...
> ...
>
> )
>
> db.provider.State.requires=IS_IN_DB(db,'states.id','%(State)s')
>
> If one fills out a form the appropriate State dropdown appears. When a
> database db select is performed the provider.State contains the number
> 3. That happens to be the proper states.id for the entry. My question
> is how does one have say 'TX' rather than 3 as the entry in
> provider.State?
>
> Sorry for the newbieness of the query.
>
> Thanks.
>
> JohnMc
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
