Hi , I'm new to Web2py and I've been struggling with this the last couple of days. I'm getting 'Rows' object has no attribute '_db'
on: query= db((db.MONITOR_CODES.MC_ID==db.MC_VALID_RESPONSES.MC_ID)&(db.MC_VALID_RESPONSES.COMPLIANCE_FLAG=='N')).select(db.MONITOR_CODES.MC_DESCR, db.MC_VALID_RESPONSES.MC_ID.count(),left=db.MONITOR_CODES.on (db.MONITOR_CODES.MC_ID==db.MC_VALID_RESPONSES.MC_ID),groupby=db.MONITOR_CODES.MC_ID) fields=[db.MONITOR_CODES.MC_DESCR, db.MC_VALID_RESPONSES.MC_ID.count()] headers={db.MONITOR_CODES.MC_DESCR: 'Non-Compliant Codes', db.MC_VALID_RESPONSES.MC_ID.count(): 'Number of Non-Compliant Responses'} form = SQLFORM.grid(query=query, fields=fields, headers=headers, sortable=True, create=False, deletable=False, editable=False, maxtextlength=64, paginate=25) Thank you for your time, Jamie -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.