Dear.
Why when i run:
def test():
return db(db.pagos.id_clientes==session.cliente_id).select(db.pagos.id,db.pagos.fecha,db.pagos.monto,db.pagos.comments,orderby=~db.pagos.fecha)
Works fine.
But when i use powerTable occur the error:
reg=db(db.pagos.id_clientes==session.cliente_id).select(db.pagos.id,db.pagos.fecha,db.pagos.monto,db.pagos.comments,orderby=~db.pagos.fecha)
powerTable = plugins.powerTable powerTable.datasource = reg
powerTable.dtfeatures['sScrollY'] = '100%'
powerTable.dtfeatures['sScrollX'] = '100%'
powerTable.dtfeatures['bPaginate'] = True
powerTable.dtfeatures['bAutoWidth'] = True powerTable._width='1020'
powerTable.dtfeatures['bSort'] = False #Se muestra ordenado por Query
#powerTable.extra=dict(editable={'editablecallback':URL('llamadas','editablefunction')})
powerTable.dtfeatures['iDisplayLength'] = 50
powerTable.virtualfields = None powerTable.headers='labels'
powerTable.showkeycolumn = False powerTable.dtfeatures['bJQueryUI'] =
request.vars.get('jqueryui',True)
powerTable.uitheme =
'redmond'#request.vars.get('theme','cupertino')#'smoothness' / 'redmond'
powerTable.dtfeatures['sPaginationType'] =
'full_numbers'#request.vars.get('pager','full_numbers') # two_button scrolling
powerTable.columns =
['pagos.id','pagos.fecha','pagos.monto','pagos.comments']
#powerTable.extra = dict(autoresize={}) powerTable.keycolumn =
'pagos.id' powerTable.hiddecolumns=['pagos.id']
table=powerTable.create() return dict(table=table)
<type 'exceptions.AttributeError'> 'Row' object has no attribute 'pagos'
Any idea what is wrong?
--- On Mon, 12/17/12, FERNANDO VILLARROEL <[email protected]> wrote:
From: FERNANDO VILLARROEL <[email protected]>
Subject: Re: [web2py] 'Row' object has no attribute powerTable
To: [email protected]
Date: Monday, December 17, 2012, 11:02 AM
Dear Bruno.
Yes works fine without powerTable
The problem occur when i use powerTable.
Regards
--- On Mon, 12/17/12, Bruno Rocha <[email protected]> wrote:
From: Bruno Rocha <[email protected]>
Subject: Re: [web2py] 'Row' object has no attribute powerTable
To: [email protected]
Date: Monday, December 17, 2012, 1:04 AM
what happens if you just return the Rows without using powerTable, it works?
def test():
return db(db.pagos.id_clientes==session.cliente_id).select(db.pagos.id,db.pagos.fecha,db.pagos.monto,db.pagos.comments,orderby=~db.pagos.fecha)
--
--
--
