marianela Posted February 15, 2007 Share Posted February 15, 2007 Hi all¡¡ i'm trying to use this query (Ireport 1.2.7): Code:...where (fac.id_cliente = $P{p_cliente} or $P{p_cliente} = 0)and (srv.id_serv_gen = $P{p_servicio} or $P{p_servicio} = 0)and fac.fecha_caducidad >= to_date($P{p_vencini},'dd-MM-yyyy') and fac.fecha_caducidad <= to_date($P{p_vencfin},'dd-MM-yyyy') and sysdate > fac.fecha_caducidad and fac.factura_pagada in ('N','P')... But I'm still getting an ORA-01858: a non-numeric character was found where a numeric was expected error. I don't understand where is my error¡¡¡ Please, if somebody could point to me the error or could explain me why I can't run this query, I will be very grateful :) Thanks alot in advanced... Regards,Marianela ;)Post edited by: marianela, at: 2007/02/15 11:42 Link to comment Share on other sites More sharing options...
marianela Posted February 15, 2007 Author Share Posted February 15, 2007 Please¡¡¡???Somebody¡¡¡??? I really need to achieve this.... :( Link to comment Share on other sites More sharing options...
GuyWithDogs Posted February 16, 2007 Share Posted February 16, 2007 I'm a total newbie, but the common solution (from what I've seen in reading thru the forum looking for answers to my own date questions) is to try replacing the Code:$P{} with Code:[code]$P!{} It's worth a shot... Link to comment Share on other sites More sharing options...
pcjunior Posted July 20, 2007 Share Posted July 20, 2007 using Oracle database you can use the following where trunc(dt_real) between to_date($P{p_dt_inic},'dd-mon-yyyy') and to_date($P{p_dt_fim},'dd-mon-yyyy') the default parameter should be "02-jan-2007" Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now