Sorry, I was typing while you were posting, I will follow your advice. Thanks, Tom
On Aug 31, 4:49 pm, tom_b <tom_blackw...@rogers.com> wrote: > I cleared all history, prefs, etc. from Firefox, it now has the same > problem as IE8 and Safari - no selection list appears. > Interestingly, the drop-downs for database administration for the > included examples (/examples/appadmin/index) work fine. I notice that > db.py for the examples uses different syntax, "Field" instead of > SQLField. It would seem that SQLField has a problem. > > On Aug 31, 3: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 -~----------~----~----~----~------~----~------~--~---