Ok, finally figured out my problem. Back when pydal was first announced, I did a pip install of pydal. Subsequently, I did a clean install of web2py using git clone. Must have gotten my pydal stuff out of sync, or didn't update it.
I used pip to uninstall pydal and then ran git submodule update --init --recursive ...in my web2py directory. Now it all works. So, I had some modules out of sync between pydal and web2py. What is the proper way to handle these dependencies/requirements when upgrading with git? -Jim On Monday, April 20, 2015 at 6:31:36 PM UTC-5, Jim S wrote: > > I just grabbed the latest, timestamp looks like this: > > Version 2.10.4-beta+timestamp.2015.04.20.18.00.31 > > and still having the same issue. > > -Jim > > On Monday, April 20, 2015 at 6:03:03 PM UTC-5, Massimo Di Pierro wrote: >> >> re-pushing. Check the nightly built in 20 minutes. >> >> On Monday, 20 April 2015 16:58:04 UTC-5, Jim S wrote: >>> >>> So this fix isn't in the web2py 2.10.4 beta that was built on 4/18? >>> >>> -Jim >>> >>> On Mon, Apr 20, 2015 at 4:55 PM, Niphlod <nip...@gmail.com> wrote: >>> >>>> we're waiting for 2.10.4 including >>>> https://github.com/web2py/pydal/issues/135 >>>> >>>> On Monday, April 20, 2015 at 9:46:58 PM UTC+2, Jim S wrote: >>>>> >>>>> I posted in this thread >>>>> https://groups.google.com/forum/#!topic/web2py/2i9zfAzG2s8 but posted >>>>> after it was closed. Evidently, this is fixed but I'm still not seeing >>>>> my >>>>> 'formats' for foreign keys. Here are the details: >>>>> >>>>> I have this in my db.py: >>>>> >>>>> db.define_table('customer', >>>>> Field('customerId', 'id', readable=True, writable=False, >>>>> label='Customer #'), >>>>> Field('name', length=30, required=True, writable=False, >>>>> requires=IS_NOT_EMPTY()), >>>>> Field('city', length=30, writable=False), >>>>> Field('state', length=2, writable=False), >>>>> format='%(customerId)s - %(name)s - %(city)s, %(state)s') >>>>> >>>>> db.define_table('equip_order', >>>>> Field('id', 'id', readable=False, label='Order #'), >>>>> Field('order_type', 'reference orderType', label='Order Type', >>>>> ondelete='RESTRICT', >>>>> requires = IS_IN_DB(db(db.orderType.equipment==True), >>>>> 'orderType.id', '%(name)s', zero='..')), >>>>> Field('status', length=10, default='New', >>>>> requires=IS_IN_SET(('New', 'Submitted', 'Invoiced'))), >>>>> Field('customer', 'reference customer', label='Customer', >>>>> ondelete='RESTRICT')) >>>>> >>>>> When I display (VIEW MODE) the customer field in the equip_order table >>>>> in a custom SQLFORM.grid form using: >>>>> >>>>> {{=form.custom.widget.customer}} >>>>> >>>>> ...it displays the id of the customer, not the name. >>>>> >>>>> I thought the 'format' on the customer table definition would control >>>>> this. I know I can fix it by changing the definition of the customer >>>>> field >>>>> in the equip_order table to: >>>>> >>>>> Field('customer', 'reference customer', label='Customer', >>>>> ondelete='RESTRICT', >>>>> represent=lambda x, r: '%s - %s - %s, %s' % >>>>> (db.customer(x).customerId >>>>> db.customer(x).name, >>>>> db.customer(x).city, >>>>> db.customer(x).state) if x else ''), >>>>> >>>>> Should I have to do that, or should the 'format' on customer take care >>>>> of it? >>>>> >>>>> -Jim >>>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "web2py-users" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/web2py/j4MhaEfBNuQ/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.