Great! Alan, Thank you. I'll give it a shot and paste my results later
tonight.
Cheers,
JJ
On Saturday, March 9, 2013 6:13:24 PM UTC-5, Jamie Jernigan wrote:
>
> 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.
