PreparedStatement

[Manuel Paco]

Would you please tell what is wrong with my "String query" ? . DATEVALUE('?') does not seem to work.
DATEVALUE('2001-10-10') is a MS-Access function.

 
   private Connection connection;
   private PreparedStatement pstmt;
   private ResultSet resultSet;
   ....
  private void getTable()
   { 
      try 
        {
         prepareSQLString("2001-10-15");
         displayResultSet( resultSet );
        }
      catch ( SQLException sqlex ) 
       {
         sqlex.printStackTrace();
       }
   }

  public void prepareSQLString(String stringDate)
  {
    String query = "SELECT * FROM addresses WHERE dateofinput = DATEVALUE('?') ORDER BY lastname";
    try
      {
        pstmt = connection.prepareStatement(query);
        pstmt.setString(1, stringDate);
        resultSet = pstmt.executeQuery();
      }
    catch (SQLException e)
      {
        System.out.println(e.toString());
      }
  }

[Jamie Robertson]

try losing the single quotes(not necessary with preparedStatements):

     String query = "SELECT * FROM addresses WHERE dateofinput = DATEVALUE([B]?[/B]) ORDER BY lastname";

it worked for me.
Jamie

[This message has been edited by Jamie Robertson (edited October 17, 2001).]

[Manuel Paco]

Thanks Jamie.