On Thursday, November 17, 2011 2:37:04 AM UTC+5:30, Martin wrote: > > Hi, > > I upgraded web2py to latest version. everything works fine exept the > autocomplete widget > > I use MySQL as my database. > > The autocomplete is reading from a db VIEW. The reason for this is > that I have 2 columns in a db: > > short_name and ISIN that is the name, and ISIN that is the ID. By > doing union select it worked fine until I upgraded. > > after the upgrade to the latest version it is not recognising the VIEW > as a DB. in my db setup I have set it to be a DB with migrate=False. > > I have tried to use the widget directly with a DB, and then it works fine. > > Initially I thought the problem were due to new adapter: pymysql, but > I have changed it using: > > import MySQLdb > from gluon.dal import MySQLAdapter > MySQLAdapter.driver = MySQLdb > > but that is not the problem. > > It does not read the VIEW as a DB anymore.. > > I have several VIEW's in my DB and it works fine for all other queries.. > > any idea how to fix it ? > > > regards > martin > >
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
