Re: [web2py] Re: Question about a field boolean in MSSQL

2014-10-26 Thread Gianganh Nguyen
gt; Anthony > > > On Friday, October 24, 2014 7:14:47 AM UTC-4, Gianganh Nguyen wrote: >> >> Sorry, this issue just occur in *mssql2.* >> >> >> Vào 17:36:52 UTC+7 Thứ sáu, ngày 24 tháng mười năm 2014, Gianganh Nguyen >> đã viết: >>

[web2py] Re: Question about a field boolean in MSSQL

2014-10-24 Thread Gianganh Nguyen
Sorry, this issue just occur in *mssql2.* Vào 17:36:52 UTC+7 Thứ sáu, ngày 24 tháng mười năm 2014, Gianganh Nguyen đã viết: > > > Hello to everybody, > I have a question, please answer for me! > > In the model, I define a field: > > *

[web2py] Question about a field boolean in MSSQL

2014-10-24 Thread Gianganh Nguyen
Hello to everybody, I have a question, please answer for me! In the model, I define a field: *db.define_table('mytable',* * Field('is_imported', 'boolean', default = False), ...)* *db.**mytable* *.insert(is_imported = True,..)* *db.**mytable**.insert(is_imported = False

Re: [web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2014-01-22 Thread Gianganh Nguyen
his error? Or, if you didn't, do you know how > I can fix this? > > > - Josh > > > > > On Thursday, December 26, 2013 10:13:36 PM UTC-5, Gianganh Nguyen wrote: >> >> Hey, >> I resolved this issue follow: >> 1. Setup pyodbc-3.0.7.win32-py2.7.exe

[web2py] Re: Important New Year News: Edison Award

2014-01-19 Thread Gianganh Nguyen
Best wish for you and web2py. :) Vào 11:08:38 UTC+7 Thứ bảy, ngày 04 tháng một năm 2014, Massimo Di Pierro đã viết: > > Web2py/me have been nominated for the Edison Award. Please wish web2py > (and me) good luck. :-) > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-26 Thread Gianganh Nguyen
Hey, I resolved this issue follow: 1. Setup pyodbc-3.0.7.win32-py2.7.exe (download from http://code.google.com/p/pyodbc/downloads/list) 2. Insert to the db.py file: *import pyodbc from gluon.dal import MSSQLAdapterif not (MSSQLAdapter.driver):MSSQLAdapter.driver = globals().get('pyodbc',

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-25 Thread Gianganh Nguyen
This error is produced when the controller files execute a query string, example db(db.usr).select() or db(db.usr).count(). It does not always occur but frequently occur! But after I press F5, it is okay. Vào 06:17:49 UTC+7 Thứ năm, ngày 26 tháng mười hai năm 2013, Alan Etkin đã viết: > > In we

[web2py] error ('', 'SQL_INVALID_HANDLE') when DAL is mssql

2013-12-25 Thread Gianganh Nguyen
Hi everybody, In web2py, if I use db = DAL('mssql://...), the error ('', 'SQL_INVALID_HANDLE') frequently occurs. But if I use db = DAL('sqlite://storage.sqlite', pool_size = 1, check_reserved = ['all'], migrate_enabled = True), everything is okie. Please help me! -- Resources: -

[web2py] error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-25 Thread Gianganh Nguyen
Hi everybody! In web2py, if I use db = DAL('mssql://...), the error ('', '*SQL_INVALID_HANDLE*') frequently occurs. But if I use db = DAL('sqlite://storage.sqlite', pool_size = 1, everything is okie. Please help me! -- Resources: - http://web2py.com - http://web2py.com/book (Docume

[web2py] error ('', 'SQL_INVALID_HANDLE') when DAL is mssql

2013-12-25 Thread Gianganh Nguyen
Hi everybody, In web2py, if I use db = DAL('mssql://...), the error ('', '*SQL_INVALID_HANDLE*') frequently occurs. But if I use db = DAL('sqlite://storage.sqlite', pool_size = 1, everything is okie. Please help me! Thanks! -- Resources: - http://web2py.com - http://web2py.com/boo