| Problem with Parameter [message #248906] |
Thu, 19 July 2007 11:17  |
Eclipse User |
|
|
|
Hi all,
This is regarding BIRT, while i am generating a report i've problem with
query, that is :
select
CLASSICMODELS.ORDERS.ORDERNUMBER,CLASSICMODELS.ORDERS.ORDERD ATE,CLASSICMODELS.ORDERS.STATUS,CLASSICMODELS.ORDERS.CUSTOME RNUMBER
from CLASSICMODELS.ORDERS
where CLASSICMODELS.ORDERS.ORDERDATE between (to_date ('?', 'yyyy/mm/dd')
and to_date ('?', 'yyyy/mm/dd') )
and I've used one more query that is:
received_date BETWEEN TO_DATE('07-JUL-2007 00:00:00', 'DD-MON-YYYY
HH24:MI:SS') AND TO_DATE('07-JUL-2007 11:59:59', 'DD-MON-YYYY HH24:MI:SS')
But in Both scenario i am getting Exception like:
A Birt exception occurred : error evaluating java script expression script
engine error: missing ; before statement script source
peram binding (From_date), line:0 , text: 01-jan-2003 00:00:00 AM see next
expression for more information,
error evaluating java script expression script engine error. missing ;
before statement script source parambinding(From_Date),
line 0, text 01-jan-2003 00:00:00 AM
reason
A BIRT exception occurred.
Could you please any body help me ...
This is very urgent task to me.
Thanks,
Red.
|
|
|
| Re: Problem with Parameter [message #248992 is a reply to message #248906] |
Thu, 19 July 2007 21:34  |
| Eclipse User |
|
|
|
Hi Red
First, do you use sampleDB of BIRT? If so, the sampleDB is derby database,
it doesn't implement to_date() function.
Second, in BIRT query, ? is considered as parameter but not '?'.
So you can try
select ordernumber, orderdate, status, customernumber
from orders
where orderdate between ? and ?
Then specify defult value of two parameters in dataset. And default value
should be like below:
"2003-01-06"
Regards!
|
|
|
Powered by
FUDForum. Page generated in 0.06333 seconds
Home