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 <d.as...@web.de> 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

Reply via email to