Replace
fields =
(db.file_transaction.file_id,db.file_transaction.source_office_id, \
db.file_transaction.destination_office_id,
db.file_transaction.transaction_date_time)
with
fields =
[db.file_transaction.file_id,db.file_transaction.source_office_id, \
db.file_transaction.destination_office_id,
db.file_transaction.transaction_date_time]
On Monday, 17 December 2012 08:58:36 UTC-6, software.ted wrote:
>
> I am trying to set the fields to display in my grid...I am following the
> slice at http://www.web2pyslices.com/slice/show/1471/sqlformgrid ,
> however, I am having an error with fields...I am using it as follows and I
> getting an error as below:
>
> links = [lambda row: A('View
> Post',_href=URL("administration","file_details",args=[row.file_transaction.file_id]))]
> fields =
> (db.file_transaction.file_id,db.file_transaction.source_office_id, \
> db.file_transaction.destination_office_id,
> db.file_transaction.transaction_date_time)
> query = ((db.file_subject_issue.circulation_status==True) &
> (db.file_transaction.file_subject_issue_id == db.file_subject_issue.id))
> form = SQLFORM.grid(query,searchable=True,links=links, fields=fields,
> deletable=False, \
> details=False, editable=False, \
> selectable=False,csv=False , paginate=20,
> user_signature=False)
>
> Error:
>
> <type 'exceptions.AttributeError'> 'tuple' object has no attribute 'append'
>
>
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
>
> Traceback (most recent call last):
> File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
>
> exec ccode in environment
> File
> "/home/www-data/web2py/applications/intranet/controllers/administration.py"
> <https://192.168.0.251/admin/default/edit/intranet/controllers/administration.py>,
> line 175, in <module>
>
> File "/home/www-data/web2py/gluon/globals.py", line 188, in <lambda>
>
> self._caller = lambda f: f()
>
> File
> "/home/www-data/web2py/applications/intranet/controllers/administration.py"
> <https://192.168.0.251/admin/default/edit/intranet/controllers/administration.py>,
> line 70, in file_track
>
> selectable=False,csv=False , paginate=20, user_signature=False)
>
> File "/home/www-data/web2py/gluon/sqlhtml.py", line 1799, in grid
>
> fields.append(field_id)
> AttributeError: 'tuple' object has no attribute 'append'
>
>
> -- Teddy L
>
--
