I´ve elready tried to change the controller/plugin_jqgrid.py, by
replacing
table=db[tablename]
if request.vars.fieldname:
dbset =
db(table[request.vars.fieldname]==request.vars.fieldvalue)
else:
dbset = db(table.id>0)
with:
table=db_1[tablename]
if request.vars.fieldname:
dbset =
db_1(table[request.vars.fieldname]==request.vars.fieldvalue)
else:
dbset = db_1(table.id>0)
But without success.
THX
On Jul 5, 11:00 am, AsmanCom <[email protected]> wrote:
> Hi,
>
> I try to get the JQGrid Plugin (http://www.web2py.com/plugins/default/
> jqgrid) to work with multiple Databases.
>
> Like this:
>
> db_1 = DAL("sqlite://db1.db")
> db_2 = DAL("sqlite://db2.db")
> db_3 = DAL("sqlite://db3.db")
>
> plugin_jqgrid(db_1.shout)
>
> But the Grid is empty.
>
> If I do it like that, it works:
>
> db = DAL("sqlite://db1.db")
>
> plugin_jqgrid(db.shout)
>
> How to change the plugin to work with multiple Databases?
>
> P.S if I put "db=db_1" in the model/plugin_jqgrid.py it works but only
> for 1 DB.
>
> Can anyone help?
>
> THX
