hello friends,
I have prob with update Query..
1)
PreparedStatement ps=conn.prepareStatement("UPDATE tablename SET exitdate=?,exittime=? WHERE mobileno=?");
ps.setString(1,dateOfEntry);
ps.setString(2,timeOfEntry);
ps.setLong(3,mobileno);
2)
PreparedStatement ps=conn.prepareStatement("UPDATE tablename SET exitdate=? WHERE mobileno=?");
ps.setString(1,dateOfEntry);
ps.setLong(2,mobileno);
the (1) not executing wid no error.
(2) works fine ..confuse with this behaviour..
I have MySqlSERVER 5.0
and
JSP 1.2
please help me.