3 messages in com.mysql.lists.javaRe: JDBC Date Fields, can't seem to I...
FromSent OnAttachments
Eric Frazier23 Jul 2002 15:46 
Luca Lafranchi24 Jul 2002 00:44 
Eric Frazier24 Jul 2002 03:38 
Subject:Re: JDBC Date Fields, can't seem to INSERT with setDate or setTimestamp
From:Luca Lafranchi (luca@rohag.ch)
Date:07/24/2002 12:44:15 AM
List:com.mysql.lists.java

PreparedStatement pStmt = c.prepareStatement("INSERT INTO date_test (datefield,datefield2) VALUES(datefield=?, datefield2=?)");

Try using this instead: PreparedStatement pStmt = c.prepareStatement("INSERT INTO date_test (datefield,datefield2) VALUES(?, ?)");

I have "date" (not "datetime") fields in my mysql db, and the PreparedStatement works perfectly...

Ciao Luca