Not worth worrying about. After the first call on the prepared statement, all variables will be set for any subsequent calls. The nanosecond taken to set an additional couple of variables' values on the first call is negligible.
Mark -----Original Message----- From: Ramaswamy, Rathnapriya Sent: Thursday, January 24, 2002 7:32 AM Is there any difference b/w usage of these two queries while using PreparedStatement. 1) String query = "update table1 set field1 = ?, field2= ? where field3 = 'value3' and field4 = 'value4'; 2) String query = "update table1 set field1 = ?, field2 = ? where field3 = ? and field4 = ?; Thanx, Priya. ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
