Re: [dba-dev] How to set a MySQL TIMESTAMP to null

2010-06-25 Thread Alex Thurgood
Hi Fernand, oStatement.setNull(1, ) for a textfield works fine ( = long SQLType others) oStatement.setNull(2, ) for a timestamp returns 00-00-00 00:00:00 and not the Mysql (null) i tried SQLtype 0 also with same results Is this not a bug in that version (which one,

Re: [dba-dev] How to set a MySQL TIMESTAMP to null

2010-06-25 Thread Fernand Vanrie
Alex Thurgood wrote: Is this not a bug in that version (which one, by the way) of the ODBC driver ? I have had this problem for a long time, and it has caused me no end of trouble, for example when I switched to the JDBC driver and it couldn't handle default -00-00 strings. It occurs on