Laszlo Nagy wrote: > > Hi All, > > I connected to a FireBird 1.5 database this way: > > import kinterbasdb > kinterbasdb.init(type_conv=200) # See > http://kinterbasdb.sourceforge.net/dist_docs/usage.html#faq_fep_is_mxdatetime_required > > > Then I try to update the database: > > sql = "UPDATE TABLE1 SET DATEFIELD=? where ID = ?" > params=[datetime.date(2007,11,01),2341] > cursor.execute(sql,params) > > I get this error: > > kinterbasdb.ProgrammingError: (-413, 'isc_dsql_execute: \n conversion > error from string "2007-11-01"') > > What is wrong here? > > Thanks, > > Laszlo >
Just tested this against my 2.03 firebird db: import datetime import kinterbasdb as db db.init(type_conv=200) con = db.connect(dsn='myhost:fbtool-dev', user='sysdba', password='pwd') sql = "update jnp set gebdat = ? where iid = ?" params = [datetime.date(2007, 11, 01), 1000052] cur = con.cursor() cur.execute(sql,params) con.commit() It worked. What version of kinterbasdb are you using? Uwe -- http://mail.python.org/mailman/listinfo/python-list
