Hi ty for replying to my problem but I am a bit confused. I tried doing the
query you suggested and tried doing it another way
it seems my loop is never executed cause what appears there is a blank page.
Not sure what I am doing wrong
Those are the two I tried
def indv_product():
this_page = request.args(0)
user_products = db((db.product.id == this_page) &
(db.product_extended.product == this_page) & (db.user_extended.userinfo ==
db.product.userinfo)).select()
return dict(user_products=user_products)
def indv_product():
this_page = request.args(0)
user_products = db((db.product.id == this_page) & (db.product.id ==
db.product_extended.product) & (db.product.userinfo ==
db.user_extended.userinfo)).select()
return dict(user_products=user_products)
But it seems the loop doesn't work any idea
this is what I am using
{{for row in user_products:}}
and an example of how I am using row
<p><img src="{{= URL('default','download', args=row.image)}}"
alt="{{=row.product_name}}" width="400" height="425"
/>{{=row.description}}</p>
The html doesn't even appear in the view source of my browser so I am doing
something wrong
*cheers