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 <[email protected]>

> table=SQLTABLE(rows,truncate=...)
> return (table=table)
>
> in view
>
> {{=table}}
>
>
> On Thu, Dec 2, 2010 at 3:24 PM, Richard Vézina <
> [email protected]> wrote:
>
>> truncate=BIGNUMBER
>>
>> BIGNUMBER = the max string length of your longer string...
>>
>> Richard
>>
>>
>> On Thu, Dec 2, 2010 at 3:20 PM, mmartinez <[email protected]> wrote:
>>
>>> Good afternoon, everyone.
>>>
>>> My query is:
>>>
>>> I query the database controllers/default.py, is specifically
>>>
>>> left=db.clientes.on(db.accountcode.id_clientes==db.clientes.id)
>>>   rows=db().select(db.accountcode.ani, db.clientes.rsocial,
>>> left=left, orderby=db.clientes.rsocial)
>>>
>>> If I
>>>
>>> print rows
>>>
>>> the result is the following:
>>>
>>> accountcode.ani, clientes.rsocial
>>> 0,                       Boomerangip S.A.
>>> 1002,                  Boomerangip S.A.
>>> 1001,                  Boomerangip S.A.
>>> 122073,              Centro de Telecomunicaciones Ricardo Gonzalez
>>> EIRL
>>> 122074,              Centro de Telecomunicaciones Ricardo Gonzalez
>>> EIRL
>>>
>>>
>>> but my problem is when I do in view/default/lineas.html
>>>
>>> {{=rows}}
>>>
>>> record here shows me this way
>>>
>>> accountcode.ani              clientes.rsocial
>>>       0                           Boomerangip S.A.
>>>    1002                         Boomerangip S.A.
>>>    1001                         Boomerangip S.A.
>>>   122073                      Centro de Tel...
>>>   122074                      Centro de Tel...
>>>
>>>
>>> What I need is to show me full information of the column
>>> clientes.rsocial
>>>
>>> So my question would be how to solve this problem?
>>>
>>> I hope I can help, of course thank you very much.
>>>
>>
>>
>

Reply via email to