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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.