using parameters in a sql query?

Mathematic

I created a few parameters that I pass as part of a querystring to the birt report. What I don't know how to do. Is in my sql query I want to have
select * from table where product = parameter1 ;

But when I set up the query in the expression builder for the Data.

I get an error saying the syntax is not correct.

Here is the query what I am I doing wrong?

select * from ptable where product = params["product_param"].value

Thanks for any help

mwilliams

Hi Mathematic,

What you need to use is:

select *
from table
where product = ?

Then, in your edit dataSet box, you link the parameter created by the '?' to the report parameter you set up for it.

Hope this helps.