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 -~----------~----~----~----~------~----~------~--~---