5 messages in com.mysql.lists.javaTimestamp not updated when using Resu...
FromSent OnAttachments
Jean17 Sep 2004 06:48 
Mark Matthews17 Sep 2004 14:55 
Rikard Froberg18 Sep 2004 03:09 
Jean19 Sep 2004 23:44 
Jean20 Sep 2004 02:52 
Subject:Timestamp not updated when using ResultSet
From:Jean (Je@chop.co.za)
Date:09/17/2004 06:48:28 AM
List:com.mysql.lists.java

Hi,

I'm doing updates to records using JDBC but the timestamp field doesn't update.

An example: Address has only two fields Line1 - varchar(40) UpdateTime - timestamp

ResultSet rs = this.doQuery("SELECT * FROM address WHERE address.key = 1",
true); rs.updateString("Line1", "street addr"); rs.updateRow(); The above does not update the timestamp field UpdateTime

If however I do a query "Update address set line1 = 'street addr' where address.key = 1" Then the timestamp is updated.

Any idea how I can get past this problem?