You need to set the validator to get the dropbox:
db.referencing.referencedtext.requires=IS_IN_DB(db,'referenced.id','%
(referencedtext)s')
else web2py does not know which field(s) should be used to label the
references.
Massimo
On Aug 31, 2:59 pm, tom_b <tom_blackw...@rogers.com> wrote:
> Thank you for the response. Prior to performing the steps in my
> original posting, I deleted the previous installation directory and
> installed the latest version of web2py.
> The only text I've entered are the table definitions in db.py. I'm a
> bit mystified.
>
> I'm using Firefox 3.5.2. Interestingly - when I try IE8 and Safari I
> get the Date picker for the DateOriginated field, but no drop down for
> "referencedtext". On IE and Safari the text box turns pink when
> clicked on, but no selection list appears.
>
> Thanks,
> Tom
>
> On Aug 31, 2:02 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > somehow somewhere you have a IS_INT_IN_RANGE or IS_FLOAT_IN_RANGE
> > validator for the string field.
>
> > On Aug 31, 11:06 am, tom_b <tom_blackw...@rogers.com> wrote:
>
> > > I'm having a problem with a very simple use of referenced fields and
> > > the database administration UI. I encountered it while working
> > > through the web2py manual downloaded from Lulo. Here is the issue
> > > distilled:
>
> > > I create a new 'test' application, append the following to db.py
>
> > > db.define_table('referenced',
> > > SQLField('referencedtext', 'string', length = 32))
> > > db.define_table('referencing',
> > > SQLField('DateOriginated', 'datetime', notnull =
> > > True),
> > > SQLField('referencedtext', db.referenced))
>
> > > I insert a couple of records in the 'referenced' table at /test/
> > > appadmin/insert/db/referenced
>
> > > referenced.id referenced.referencedtext
> > > 1 First_referenced
> > > 2 2nd_Referenced
>
> > > I attempt to insert a record at /test/appadmin/insert/db/referencing
> > > by picking a DateOriginated and a 'referencedtext' from the drop-
> > > downs.
>
> > > This produces a red error message under the referencedtext that says
> > > "too small or too large!".
>
> > > I would appreciate advice on how to avoid this problem. I am running
> > > Version 1.66.2 (2009-08-21 12:13:57)
> > > on Windows XP.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---
