out of topics: JDBC - passing date parameter

Hi all,

I want to know how to passing date as parameter in PreparedStatement object.

Database used VFP and the JDBC Driver is dbAnywhere version 1.1.

I always got error message in my ODBC driver,

my code is like this :

PreparedStatement pstmt = con.prepareStatement("Select * from mrtable where between(chickin,?,?)");

pstmt.setDate(1,new java.sql.Date(99,5,1));

pstmt.setDate(2,new java.sql.Date(99,6,2));

ResultSet rs = pstmt.executeQuery();

thanks,

regards

yoel

Reply via email to