Problem to pass the parameter

Hi ,

Actully i am passing a parameter as a query "select distinct(card_number), trace_time,language,account_type,receipt_option,wdraw_rcpt_delivery,rcpt_delivery,method,source,amount,trans_type from cardtraces where method='POST' and (card_number like '0983%' or card_number like '9865%' or card_number like '7896%' or card_number like '4731%' or card_number like '8963%' or card_number like '7357%' or card_number like '8510%' ) and trace_time in (select MAX(trace_time) from cardtraces group by card_number) order by card_number "

this but in birt tool its not accepting this "(card_number like '0983%' or card_number like '9865%' or card_number like '7896%' or card_number like '4731%' or card_number like '8963%' or card_number like '7357%' or card_number like '8510%' )" line i am removing this line report working fine what's the problem in this line how can i pass this parameter in birt

Find more posts tagged with

Comments

mwilliams

Hi Jaibirt,

Is card_number an integer or a string?

Jaibirt

Hi Michale,

Thanks for ur response. Card_number is string data type.

mwilliams

Jaibirt,

The same type of query works for me with the sample database. If you can recreate this issue with the sample database and attach the report, that'd give me a better look at the problem. What version of BIRT are you using?

Jaibirt

I got a solution ,Actully the issue was URL encoding while we passing a parameter like "%" Browers will recognise as a Space .So now i am passing encoded value now its working.....

mwilliams

Ah, that makes sense. I hadn't thought about problems with deploying with parameters like that. Glad you got it working. Let us know if you have any other questions.