> def writeTagTest(): > a = db.tag.insert(name='red') > b = db.tag.insert(name='green') > c = db.tag.insert(name='blue') > db.product.insert(name='Test Toy Car',tags=[a, b, c]) > return dict(message="Insert ok", tag=db.tag,product=db.product) > > > def readTagTest(): > b=db(db.tag.name=='green').select().first() # > gluon.dal.Rows? > products = db(db.product.tags.contains(b)).select() # here > products is empty? Why?? >
>From the above code, it appears db.product.tags is a list:reference field, so it stores the id's of the referenced tag records. In readTagTest, "b" is a Row object, so if you want the id of that row, you should use b.id: products = db(db.product.tags.contains(b.id)).select() Anthony -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
