Problem with type Date

"luisicozgz" <[email protected]> Thu, 06 Sep 2007 13:17:04 -0000
Newsgroups gmane.text.xml.rpc.specification
Message-ID <[email protected]>
Hello,

I need to send a variable type Date from Java to PHP with XML-RPC.I 
send the Date on this way:
Date a = new Date(2007,9,5);
params.addElement(a);
client.execute(funcion,params);
but when I send the Date, I have this error in the http sniffer:

<br />

<b>Warning</b>: pg_exec(): Query failed: ERROR: invalid input syntax 
for type date: &quot;--20070905T00:00:00&quot; in 
<b>/var/www/html/dev/sonia/casas_rurales/html/web/datos/conexion.clas
s.php</b> on line <b>109</b><br />

SQL: SELECT distinct(alojamiento_id) as alojamiento_id, 
fecha_entrada,fecha_salida,numero_habitacion,nombre_zona, 
city,province,idtypelodging FROM 
v_habitacion_alojamiento_disponibilidad WHERE province ~* '8' and 
idtypelodging = '8' and alojamiento_id in (SELECT alojamiento_id 
FROM v_suma_capacidad_alojamiento WHERE suma_maxima_capacidad ='8' ) 
and numero_habitacion = '8' and alojamiento_id not in (select 
alojamiento_id from v_habitacion_alojamiento_disponibilidad where ('-
-20070905T00:00:00' between fecha_entrada and fecha_salida) or ('--
20070905T00:00:00' between fecha_entrada and fecha_salida))

Error: ERROR: invalid input syntax for type date: "--
20070905T00:00:00"<br>

¿How must I send a Date in Java with XML-RPC?¿Must I declare the 
Date of another form?

Thanks a lot.





 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/xml-rpc/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/xml-rpc/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/