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: 
&quot;--20070905T00:00:00&quot; 
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
  • [no subject] luis ......
    • Re: Jochen Wiedmann

Reply via email to