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