I think you want this:
product= db.product(this_page)
userstuff=db(db.user_extended.userinfo==product.userinfo).select()
But I am not sure. Can you explain us more?
On Oct 13, 11:13 am, Andrew Evans <randra...@gmail.com> wrote:
> How can I make these two queries into one cause when I use them in my view
> (htmll) it doesn't work as expected
>
> product=db(db.product.id == this_page).select(db.product.ALL)
>
> userstuff=db(db.user_extended.userinfo ==
> db.product.userinfo).select(db.user_extended.ALL)
>
> this is what I am doing
>
> {{for stuff, products in zip(userstuff, product):}}
>
> if anyone has suggestions on how I can get this to work. Currently the user
> stuff value always returns the first entry in the db regardless of which
> user I select
>
> Any ideas
>
> *cheers
>
> Andrew
