Date Manipulation

Hi there

Question 1)

For some reason when i am inputting data it wont let me leave a date field blank, or null. But i need to be able to do this. e.g. client walks in and we register them on our system, but one field is paid date and obviously i only want to enter that once they have actually paid. If it is default to present date then obviously it will look like they paid, or if i default it to 00-00-0000 when i click on the calendar i have a shite load of clicking to do to get to the current date. How do i allow it to stay blank?

P.S. Its not a primary key and is not set to 'not null' either.

Question 2)

See code below. What I want to do is after each block of dates i want to leave an open line satting the day of the dates to follow, e.g.

The output is Like this at the moment:

01-01-2006 ....
01-01-2006 ...
02-01-2006 ... etc.

I want:

Mon
01-01-2006 ...
01-01-2006 ...
Tue
02-01-2006 ... etc

Any Ideas?


try {
      Driver DriverRecordset = (Driver)Class.forName(_driver).newInstance();
      con = DriverManager.getConnection(_url, _uid,_pwd);
       stmt = con.createStatement();
        rs = stmt.executeQuery("select * from bookings where embassy='French' order by consulatedate asc");
      while (rs.next()){      
      
            c++;
      %>
            <TR>
                  <Td  bgcolor="#ffffff" width=80><%=rs.getString("consulatedate")%></td>
                  <Td  bgcolor="#ffffff"><a href="viewclient.jsp?id=<%=rs.getString("id")%>"> <%=rs.getString("name")%> <%=rs.getString("surname")%> </a> </td>

                  <Td  bgcolor="#ffffff" width=70><%=rs.getString("tel")%></td>
                  <Td  bgcolor="#ffffff" width=70><%=rs.getString("mobile")%></td>
                  <Td  bgcolor="#ffffff"><%=rs.getString("email")%></td>
                  <Td  bgcolor="#ffffff" width=60><%=rs.getString("traveldate")%></td>
                  <Td  bgcolor="#ffffff" width=60><%=rs.getString("documents")%></td  
            </tr>
      <%       
                }
       con.close();
}

catch (SQLException sqle) {
       out.println("SQLException" + sqle.toString());
}