On 27 June 2012 03:34, Anthony <abasta...@gmail.com> wrote:
> I wish it was possible to use other time-saving tools like SQLFORM.grid
>> with db.executesql().
>>
>> At the moment most of the representation tools like SQLTABLE and
>> plugin_wiki's jqgrid suppose DAL usage.
>>
>
> This wouldn't help with SQLFORM.grid, which does its own query, but for
> other cases where you need a Rows object with executesql, this might work:
>
> raw_rows = db.executesql('[SQL code]')
> rows = db._adapter.parse(raw_rows,
> fields=[db.mytable[f] for f in db.mytable.fields],
> colnames=db.mytable.fields)
>
>
Thanks. This help a little bit.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
