A couple of things
Put this in for the view html file temporarily
{{extend 'layout.html'}}
<hr />
{{=H2('Results')}}
{{=SQLTABLE(user_products,
headers='fieldname:capitalize',
truncate=100)
}}
and you should see a nicely formatted table of the results of the
query with the column names in the table header.
This will prove whether or not you are getting data in user_products.
If you see the expected results in the table then it is a view
problem. If the table is blank it is a controller problem.
Did you put a {{pass}} line at the point where the {{for row in
user_products:}} iteration loop should end? Indentation follows HTML
not Python rules in the {{}} code segments so pass is used to signal
the end of a block in this case "for".
http://web2py.com/book/default/chapter/05
Ron
On Oct 15, 11:29 pm, Andrew Evans <randra...@gmail.com> wrote:
> 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
