Tried that already but got the same error. Jim On Apr 12, 2013 11:32 AM, "Anthony" <abasta...@gmail.com> wrote:
> 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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.
