Eclipse Community Forums: BIRT » Problem with Parameter

Help

Home

Home » Archived » BIRT » Problem with Parameter

Show: Today's Messages :: Show Polls :: Message Navigator

Problem with Parameter [message #248906]

Thu, 19 July 2007 15:17

JP Redro

Messages: 181
Registered: July 2009
Location: India

Senior Member

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.

Thanks,
JP

Report message to a moderator

Re: Problem with Parameter [message #248992 is a reply to message #248906]

Fri, 20 July 2007 01:34

Tianli Zhang

Messages: 2862
Registered: July 2009

Senior Member

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!

Report message to a moderator

Previous Topic:	pdf emitter problem
Next Topic:	Landscape orientation for PDF not working in servlet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 27 18:40:35 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter