Hello,I need to send a variable type Date from Java to PHP with XML-RPC.Isend
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 syntaxfor type date:
"--20070905T00:00:00"
in<b>/var/www/html/dev/sonia/casas_rurales/html/web/datos/conexion.class.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
FROMv_habitacion_alojamiento_disponibilidad WHERE province ~* '8'
andidtypelodging = '8' and alojamiento_id in (SELECT alojamiento_idFROM
v_suma_capacidad_alojamiento WHERE suma_maxima_capacidad ='8' )and
numero_habitacion = '8' and alojamiento_id not in (selectalojamiento_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 theDate of another form?Thanks a lot.
_________________________________________________________________
Llama a tus amigos de PC a PC: ¡Es GRATIS!
http://get.live.com/messenger/overview