ORA-00933

[fujidaa]

I try to run below code in oracle and everything's fine. But when i try to use it in iReport (parameter replace the date) I get ORA-00933: SQL Command not properly ended .

what i need to do to make it function in iReport?

 

 

 

Code:

Oracle:SELECT Cdate, receiptFROM cashWHERE  Cdate >'20110523' AND Cdate<'20110525'ORDER BY receiptReport query in iReport:SELECT Cdate, receiptFROM cashWHERE $P{pFrom}ORDER BY receipt$P{pFrom}:" and Cdate >="+$P{pFrom}$P{pFrom} :in date format, accept data from user

[despec]

The code should be;

 

select

Cdate,

receipt

 

from

cash

 

where

Cdate >= $P{pFrom}

 

 

David

[fujidaa]

yay! thank you very much despec. it solved my problem /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif