Re: [web2py] Re: SQLFORM.grid columnas a mostrar

the question is: to define columns=['accountcode.ani','llamados.destino','llamados.answeredtime','llamados.inicio','llamados.valor'] I only show the columns that correspond to the table is llamados I need to display and just as the column of the table accountcode 2011/11/2 Massimo Di Pierro

Re: [web2py] Re: join with SQLFORM.grid

Thank you 2011/10/12 Massimo Di Pierro > SQLFORM.grid does not take rows. It take the query itself. It needs > the query to optimize the select for orderby and pagination. You can > in fact do: > > query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2) > left = > (b.on(a.id_accountcode

Re: [web2py] help with view of rows

I have worked placing table = SQLTABLE (rows, truncate = number) Now a new query I can take a SQLTables to display the plugin data_tables 2010/12/2 Richard Vézina > table=SQLTABLE(rows,truncate=...) > return (table=table) > > in view > > {{=table}} > > > On Thu, Dec 2, 2010 at 3:24 PM, Rich

Re: [web2py] Re: Renaming a column in the database web2py?

The reason for wanting to rename the column is because I am using the plugin web2py.plugin.datatable.w2p and make the query as: rows = db (db.accountcode.id_clientes == session.cliente_id). select (Db.accountcode.ani) I get the title of the column and I want to show accountcode.ani annex the title.

Re: [web2py] Re: I can not update

thanks, solved my problem 2010/6/4 mdipierro > In this > > try: > #1 > except: > # 2 > > if #1 fails because it violates a constraint, than you need to > rollback before you can access the database again. > Try this: > > t