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.


Reply via email to