Sure, and thank you for the fast response. I had logged off for the night.
Traceback (most recent call last):
File "/home/ameteq/webapps/web2py/web2py/gluon/restricted.py", line 204, in
restricted
exec ccode in environment
File
"/home/ameteq/webapps/web2py/web2py/applications/sms_test_protocol/controllers/default.py"
<https://admin.ameteq.com/admin/default/edit/sms_test_protocol/controllers/default.py>,
line 1197, in <module>
File "/home/ameteq/webapps/web2py/web2py/gluon/globals.py", line 172, in
<lambda>
self._caller = lambda f: f()
File
"/home/ameteq/webapps/web2py/web2py/applications/sms_test_protocol/controllers/default.py"
<https://admin.ameteq.com/admin/default/edit/sms_test_protocol/controllers/default.py>,
line 1006, in compliance
form = SQLFORM.grid(query=query, fields=fields, headers=headers,
sortable=True, create=False, deletable=False, editable=False, maxtextlength=64,
paginate=25)
File "/home/ameteq/webapps/web2py/web2py/gluon/sqlhtml.py", line 1455, in grid
db = query._db
AttributeError: 'Rows' object has no attribute '_db'
There was also this, I don't know if it helps:
Function argument list
(query=<gluon.dal.Rows object>, fields=[<gluon.dal.Field object>,
<gluon.dal.Expression object>], field_id=None, left=None,
headers={<gluon.dal.Field object>: 'Non-Compliant Codes',
<gluon.dal.Expression object>: 'Number of Non-Compliant Responses'},
orderby=None, searchable=True, sortable=True, paginate=25, deletable=False,
editable=False, details=True, selectable=None, create=False, csv=True,
links=None, links_in_grid=True, upload='<default>', args=[],
user_signature=True, maxtextlengths={}, maxtextlength=64,
onvalidation=None, oncreate=None, onupdate=None, ondelete=None,
sorter_icons=(<gluon.html.XML object>, <gluon.html.XML object>),
ui={'button': 'button', 'buttonadd': 'icon plus', 'buttonback': 'icon
leftarrow', 'buttondelete': 'icon trash', 'buttonedit': 'icon pen',
'buttonexport': 'icon downarrow', 'buttontable': 'icon rightarrow',
'buttontext': 'buttontext button', 'buttonview': 'icon magnifier',
'content': '', ...}, showbuttontext=True, _class='web2py_grid',
formname='web2py_grid', search_widget='default', ignore_rw=False,
formstyle='table3cols')
Code listing
1450.
1451.
1452.
1453.
1454.
1455.
1456.
1457.
1458.
1459.
)
elif not isinstance(ui,dict):
raise RuntimeError,'SQLFORM.grid ui argument must be a dictionary'
from gluon import current, redirect
db = query._db
T = current.T
request = current.request
session = current.session
response = current.response
Variables query <gluon.dal.Rows object> db undefined query._db undefined
On Saturday, March 9, 2013 10:17:10 PM UTC-5, Massimo Di Pierro wrote:
>
> Can you show the complete traceback
>
> On Saturday, 9 March 2013 17:13:24 UTC-6, 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.
