[sqlalchemy] The installed version of sqlite is out-dated..

2007-05-25 Thread anatoly techtonik
.. and will cause errors in some cases. Version 3.3.13 or greater is recommended. Does anybody know where to get these updated binaries of pysqlite for windows? Those available from official site just do not fit. --~--~-~--~~~---~--~~ You received this message

[sqlalchemy] Re: The installed version of sqlite is out-dated..

2007-05-25 Thread Michael Bayer
On May 25, 2007, at 9:02 AM, anatoly techtonik wrote: .. and will cause errors in some cases. Version 3.3.13 or greater is recommended. Does anybody know where to get these updated binaries of pysqlite for windows? Those available from official site just do not fit. 3.3.13 of sqlite:

[sqlalchemy] News about ticket #370 ?

2007-05-25 Thread Roger Demetrescu
Hi Michael, I'm having the same problem described in ticket 370. Eg.: mapper(User, users_table, properties = dict( preferences = relation(UserPrefs, cascade=all, delete-orphan), )) when I try to do this: u = session.query(User).get(1) u.preferences.clear() session.flush() it thows a

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-25 Thread jason kirtland
FYI the MySQLdb 1.2.1 gammas 1 through 3 seem to have this blob issue. 1.2.1 and 1.2.2 final are both OK. Mike wrote: will try one a few systems and different MYSQLdb The mysqlDB 1.2.1gamma3 __author__ = Andy Dustman [EMAIL PROTECTED] __revision__ = $Revision: 1.36.2.4 $[11:-2]

[sqlalchemy] Re: error after insert using mssql and sqlalchemy 0.3.7

2007-05-25 Thread Jin Lee
Rick, Paul - Sorry for the late reply (my day job has been keeping me quite busy) It looks like ?use_scope_identity=0 works, I am no longer getting the error. Rick, to answer your questions, the pk is a field of type IDENTITY. I am using pyodbc 2.0.35, and MSSQL 2000 SP 4 Thanks guys, Jin

[sqlalchemy] Re: Exception raised on insert blob.

2007-05-25 Thread Mike Bernson
moving to mysqldb 1.2.1-p2 fixed the problem. It was a mysqldb issue. Just a note this is the standard setup for ubuntu dapper. We use the LTS version of unbuntu on server and client matchines. We might want something in the faq about min version of mysqldb or note about known broken version

[sqlalchemy] Re: News about ticket #370 ?

2007-05-25 Thread Michael Bayer
ive turned off firebird's supports_sane_rowcount feature, update to rev 2642 for now. On May 25, 2007, at 2:43 PM, Roger Demetrescu wrote: Hi Michael, I'm having the same problem described in ticket 370. Eg.: mapper(User, users_table, properties = dict( preferences =

[sqlalchemy] Re: News about ticket #370 ?

2007-05-25 Thread Roger Demetrescu
Thanks Michael, I'll give it a try at monday morning... Have a nice weekend... :) []s Roger On 5/25/07, Michael Bayer [EMAIL PROTECTED] wrote: ive turned off firebird's supports_sane_rowcount feature, update to rev 2642 for now. On May 25, 2007, at 2:43 PM, Roger Demetrescu wrote: