Since you are joining tables, you might need to use the "tablename.fieldname" format to refer to the field in question. Does '%(product.productName)s' work (assuming "productName" is in the db.product table)?
Anthony On Friday, April 12, 2013 11:59:59 AM UTC-4, Jim S wrote: > > requires = > IS_IN_DB(db((~db.productSite.productSiteId.belongs(currentItems)) & > (db.productSite.availableAddon==True) & > (db.productSite.siteId==workorder.siteId) & > > (db.product.productId==db.productSite.productId)), > db.productSite.productSiteId, > '%(productName)s', zero='..') > > I get a trace back with this. If I pull out the '%(productName)s' it > works. But, I want to specify the field name to display being a field in > the table linked by the 4 'anded' query. > > Help? > > -Jim > -- --- 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/groups/opt_out.