Eclipse Community Forums: BIRT » Multiple parameters

Home » Archived » BIRT » Multiple parameters

Tue, 10 July 2007 07:33

Eclipse User

Originally posted by: westland.nachon.nl

Hi,

I want to execute to following SQL statement:

SELECT * FROM MYTABLE T1
WHERE
T1.number = 0
OR
T1.number <> 0 AND T1.adress = 1

number is going to be a parameter, so the statement will be:
SELECT * FROM MYTABLE T1
WHERE
T1.number = ?
OR
T1.number <> ? AND T1.adress = 1

Can this be done with 1 parameter?

Grz,
Rob

Re: Multiple parameters [message #247203 is a reply to message #247171]

Tue, 10 July 2007 09:17

Eclipse User

Hi Rob

There are two ? in your query, so there must be two parameters to be
specify. If you left one empty or only use one parameter is not allowed.

regards

Re: Multiple parameters [message #247364 is a reply to message #247203]

Wed, 11 July 2007 09:56

Eclipse User

Originally posted by: westland.nachon.nl

Tianli schreef:
> Hi Rob
>
> There are two ? in your query, so there must be two parameters to be
> specify. If you left one empty or only use one parameter is not allowed.
>
> regards
>

The example I gave was just a simple one. My actual expression is a
little longer. I want to use the same parameter 5 times in 1 expression.
Do I have to repeat the parameter 5 times?

SELECT * FROM MYTABLE T1
WHERE
T1.number = ?
OR
T1.number = ? AND T1.adress1 = 1
OR
T1.number = ? AND T1.adress2 = 2
OR
T1.number = ? AND T1.adress3 = 3
OR
T1.number = ? AND T1.adress4 = 4

Re: Multiple parameters [message #247387 is a reply to message #247364]

Wed, 11 July 2007 10:25

Eclipse User

Hi Rob,

u can write script for that datset in beforeOpen and u can write u'r own
logic for that like...,

Don't attach the parameter directly to the dataset at this case

var Duration30Plus_val = reportContext.getParameterValue("Duration 30
Plus");

var query=this.queryText;

var where = "where";
if(AppID_val != null && AppID_val != ""){
query=query+" "+where+ " WW_ADMIN.WW_APPOINTMENT.APPOINTMENT_ID " +
AppID_op + " " + AppID_val +" ";
where = "and";
}

if(Title_val != null && Title_val != ""){
query=query+" "+where+ " WW_ADMIN.WW_APPOINTMENT.TITLE " + Title_op + "
'" + Title_val +"'";
where = "and";
}

Previous Topic:	Birt classloader changes
Next Topic:	Connection is not getting released by IGetParameterDefinitionTask

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 23:14:11 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter