Hi,
   I just wondered if there is a way of stopping an exception being raised
when my SQL query returns an empty result set?
I am using an ODBC connection to a MySQL database.
My code for using the result set is shown below:

ResultSet rs = st.executeQuery(DateOD);
    //Only one row returned no need for looping
    if (rs.next()) {
     //if the result set is not empty return the date
     java.sql.Date DOD = rs.getDate(1);
     return DOD;
    }
    //date chosen to indicate failure - could not work out how to return
null
    else {
    System.out.println("fake date:"+java.sql.Date.valueOf("?-?-?"));
    return java.sql.Date.valueOf("?-?-?");
    }
 }
 catch(Exception ex)
     {System.out.println("Problem executing query "+ex+" ");
   //date chosen to indicate failure - could not work out how to return
null
        return java.sql.Date.valueOf("2200-01-01");
     }

This code generates an exception:
Problem executing query java.lang.NumberFormatException: ?

While I am asking database questions. Is there a way of returning a
java.sql.Date null value? So far I have been substituting an incorrect date
as a substitute for a null.

Thanks in advance.

Paul