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: "--20070905T00:00:00" 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/