[web2py] Simple problem: 'Rows' object has no attribute...

[ztd]

Hi,

here is an error I receive in a simple stock tracking application I'm
making to help me learn Web2Py:

Traceback (most recent call last):
  File "gluon/restricted.py", line 178, in restricted
  File "C:\Users\Zac\Desktop\web2py\applications\shares/views\default/
index.html", line 86, in <module>
AttributeError: 'Rows' object has no attribute 'asx_code'

I think the problem is to do with passing variables between the
controller and view. I've based this app on the 'image blog' example
in the book. Here is my code so far:

---db.py---

db.define_table('shares',
    Field('asx_code'),
    Field('date_added','datetime',default=request.now),
    Field('quantity'),
    Field('buy_price'))

db.define_table('prices',
    Field('share_id',db.shares),
    Field('date','datetime',default=request.now),
    Field('price_low',default='0'),
    Field('price_high',default='0'),
    Field('price_close',default='0'))

db.shares.asx_code.requires =
[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,db.shares.asx_code)]
db.shares.quantity.requires = IS_NOT_EMPTY()
db.shares.buy_price.requires = IS_NOT_EMPTY()

db.prices.share_id.requires = IS_IN_DB(db,db.shares.id,'%(asx_code)s')

db.prices.share_id.writable = db.prices.share_id.readable = False


---index in default.py---

def index():
    shares=db().select(db.shares.ALL, orderby=db.shares.asx_code)
    return dict(shares=shares)


---default/index.html---

{{extend 'layout.html'}}
<h1>Share portfolio</h1>
<ul>
{{for asx_code in shares:}}
{{=LI(shares.asx_code)}}
{{pass}}
</ul>


What am I doing wrong? i'm a bit confused with variables in the
controller, I have a table called shares, a variable declared in the
controller called shares and the value in the dictionary called shares
so it's very hard to know what I'm calling / using in the view!!! (the
LI code could be wrong, I couldn't get it to show anything to debug
that far). shares table contains two entries.

Thanks!