>
> 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)
Anthony
--
