I do a similar set of steps, yet one of the sets acts differently. I'm trying to loop through a query return (Rows), but I'm obviously missing something basic.
I do a query and 'print' the return. Here's a snippet from my controller: line 144: instAttch = db((db.Meet.id == request.args(1)) & (db.Addl_institution_info.Start_date < db.Meet.Start_date) & (db.Addl_institution_info.End_date > db.Meet.Start_date) & (db.Participant_team.Is_home_team)).select( db.Addl_info_item.ALL, join = [db.Participant_team.on( db.Meet.id == db.Participant_team.Meet), db.Team.on(db.Participant_team.Team == db.Team.id), db.Institution.on(db.Team.Institution == db.Institution.id), db.Addl_institution_info.on( db.Addl_institution_info.Institution == db.Institution.id), db.Addl_info_item.on(db.Addl_info_item.id == db.Addl_institution_info.Addl_info_item)]) ... Later in the same function (displayed with line numbers): 240: print 'Start loop at 240; instAttch:\n' 241: print instAttch 242: for attch in instAttch: 243: print 'attch:\n' 244: # 245: print attch 246: if attch.Addl_info_item.Email_text: The output from line 241 looks like a Rows object to my rookie eye: Start loop at 240; instAttch: Addl_info_item.id,Addl_info_item.File_path,Addl_info_item.Email_text,Addl_info_i tem.Content_id,Addl_info_item.Internal_description 2,C:\Users\mjf\Documents\MJF\WebSite\NCAA\private\Test DU Parking pass.dat,Test email text: addl_info_item 2,,item 2 attch: <Row {'Internal_description': 'item 2', 'Addl_pool_info': <gluon.dal.Set object at 0x05DAA4D0>, 'update_record': <function <lambda> at 0x05F158B0>, 'Addl_instit ution_info': <gluon.dal.Set object at 0x05DAA6B0>, 'File_path': 'C:\\Users\\mjf\ \Documents\\MJF\\WebSite\\NCAA\\private\\Test DU Parking pass.dat', 'Email_text' : 'Test email text: addl_info_item 2', 'Content_id': '', 'Addl_meet_info': <gluo n.dal.Set object at 0x05DAA1F0>, 'id': 2, 'delete_record': <function <lambda> at 0x05F15F30>}> I do a 'for ...' on instAttch at line 242 and get: <type 'exceptions.KeyError'> 'Addl_info_item' The traceback tells me it's at line 246: if attch.Addl_info_item.Email_text: What am I missing? --