Hmm. Unfortunately I receive -- File "/home/rootuser/web2py/gluon/sqlhtml.py", line 544, in accepts fields[fieldname] = int(fields[fieldname]) ValueError: invalid literal for int() with base 10: 'TX'
Thanks On Apr 15, 3:06 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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 -~----------~----~----~----~------~----~------~--~---