[web2py] Re: Problem accessing Rows/Row

2012-09-14 Thread MichaelF
Yes, it makes sense, and I've already modified my code; thanks. It's the inconsistency that gets me. It's not a big deal, but still. If I add another field from another table to my select, then I have to change all my field references to include the table references. I suspect the Rows/Row iter

[web2py] Re: Problem accessing Rows/Row

2012-09-14 Thread lyn2py
If you have data from one table only, leave out the table name. (which is in your case) If you have data from more than one table, you need to use the table name to access the correct info. This has always been the way web2py functions. :) I think it is a matter of perspective. When you only a

[web2py] Re: Problem accessing Rows/Row

2012-09-13 Thread MichaelF
The problem is that I need to change the problem line from: 246:if attch.Addl_info_item.Email_text: to: 246:if attch.Email_text: My previous 'select' statements retrieved fields from several tables, while this one (the 'problem' one) retrieves from only one table. So, if I understand co

[web2py] Re: Problem accessing Rows/Row

2012-09-13 Thread villas
I don't really know, but I would suggest playing around with things on the commandline. python web2py.py -S yourapp -N -M >>> rows = db(db.Addl_info_item.id > 0).select() >>> for f in rows[0]: print f >>> for r in rows: print r.Email_text etc etc You can put more and more code in there and h