[web2py] MSSQL2Adapter

Hello Rather than storing strings as UTF8 in VARCHAR, I would like to store the strings as NVARCHAR in MSSQL. It appears that is what MSSQL2Adapter is meant to do, but there were errors when I tried to use it. I believe a couple changes in the MSSQLAdapater code could make it work (it seems to wor

Re: [web2py] Re: MSSQL2Adapter

On Mon, Jun 27, 2011 at 3:41 PM, Massimo Di Pierro wrote: > Your suggested change is in trunk. I am trusting you one this since I > am not a MSSQL user and cannot test it. If anybody else is using > MSSQL2Adaperter, i.e. > >   DAL('mssql2://') > > please check that this change does not break y

Re: [web2py] Re: validator formatter when validation fails

thanks, it works for me On Mon, Feb 17, 2020 at 9:16 PM Massimo Di Pierro wrote: > > I think this is fixed now. Please give it a try. > > On Monday, 17 February 2020 13:53:34 UTC-8, Eric wrote: >> >> In py4web, when form validation fails on a datetime field, py4web throws and >> exception. >> In

Re: [web2py] py4web psycopg2 error

you need to install psycopg2 package pip3 install psycopg2 or pip3 install psycopg2-binary On Tue, Feb 18, 2020 at 7:52 AM Maurice Waka wrote: > > SO I start importing/changing from web2py to py4web. > File > "/home/maurice/.local/lib/python3.6/site-packages/pydal/adapters/base.py", > line 13

Re: [web2py] Using postgresql with py4web gives error

If you are using ## in the password, that might cause problems for the URL/URI parser since # is part of URL structure. Otherwise, it looks like postgres is not running. On Wed, Feb 19, 2020 at 10:32 AM Maurice Waka wrote: > > db = DAL( "postgres://mauricewaka:b123test##@localhost:5432/mydb") >