Re: [web2py] use executesql results in grid

2014-04-15 Thread Niphlod
yep but valid only for read-only grid. You need a unique integer value to use the grid for editing purposes > >> > What I do is to either create a database view or a table containing the > result and then in the controller define a model with 'migrate = False' to > read the view/table and then

Re: [web2py] use executesql results in grid

2014-04-14 Thread Johann Spies
On 14 April 2014 18:35, Yufei Li wrote: I am doing a quite complicated sql select with selects nested, which I do > not know how to create using DAL, so I decided to go with executesql with > fields specified. My questions is once I get back results of 'gluon.dal.Rows'> type, is there a way to c

[web2py] use executesql results in grid

2014-04-14 Thread Yufei Li
I am doing a quite complicated sql select with selects nested, which I do not know how to create using DAL, so I decided to go with executesql with fields specified. My questions is once I get back results of type, is there a way to create a SQLFORM.grid with them? I am able to use SQLTABLE, bu