Hi 
you must use java.sq.date and see the documentation of
it
julio oliveira
buenos aires
argentina


 --- Javier <javiera25@w...> escribió: > ?m
having problems to compare dates in JSP
> 
>     String fec1=?01-12-2001?;
>     String consultaSQL = "SELECT REGISTRO, TITULO,
> APELLIDOS,
> RES_FECHA "+
>          "FROM RESERVAS, LIBROS, USUARIOS "+
>          "WHERE
> LIBROS.REGISTRO=RESERVAS.RES_REGISTRO "+
>          "AND
> USUARIOS.MATRICULA=RESERVAS.RES_MATRICULA "+
>          "AND RES_FECHA = #"+fec1+"#";
> 
>         consulta = conexion.createStatement();
>         resultado 
> consulta.executeQuery(consultaSQL);
> 
> 
>        only works if I change
> 
>        String fec1=?2001-12-01?;
> 
>        ¿Anybody knows where is the problem?
> 
>        Thanks,
> 
>        Francisco
> 
> PS. I?m working with Windows 98 second edition,
> Access 97 and Tomcat 4
> 
> 
> 
> ---
> Do you need true END-TO-END (e2e) Java Messaging
> (JMS)?  Softwired
> offers industry's ONLY complete 100% JMS messaging
> solutions for your
> needs TODAY.
> Visit
>
http://adtracking.wrox.com/track.asp?x=p2p%2Fe%2Fjava%2Dsoftwired&url=www.softwired-inc.com
> NOW and find
> out more!
> Our unique product range includes: iBus//Mobile
> (wireless data),
> iBus//MessageBus (IP Multicast), iBus//MessageServer
> (store and forward)
> and much more!
> 
$subst('Email.Unsub'). 

=====
Julio Oliveira
Oliveira_julio@y...

Club de Usuarios de Java de Argentina
Subscribite en :

mailto:AUBA-JBuilder-subscribe@y...

Conectate a Internet GRATIS con Yahoo! Conexión: 
http://conexion.yahoo.com.ar