how to do IN clause in BIRT

vidu

HI

i saw this example in BIRT forum , at the propertybinding

it says
if (params["custList"].equals("*")) {
this.queryText = "select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CLASSICMODELS.CUSTOMERS.CUSTOMERNAME from CLASSICMODELS.CUSTOMERS";
} else {
var endOfQuery = "WHERE CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER IN(" + params["custList"] +")";
this.queryText = "select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CLASSICMODELS.CUSTOMERS.CUSTOMERNAME from CLASSICMODELS.CUSTOMERS " + endOfQuery;

i have a bigger query how can i add this in this auery i gave is in a one straight like .. but i cannot put my query like that ..

as my query is very long and it's very painful to make that as a one long list of string

is there any other way to do this... i'm trying to pass the multiple values via a the jsp to like this &keyNO=1,3,56,3

can i do this ...please help

vidu

vidu

hey guys

I finally found the answer....

just got to add +" " for every new line of query this is **** hard ... wehn my query is so long..

why nobody's answering ... so worried...



anyways .. guys ... that's something i found out today it'w working you can do IN and LIKE CLAUSE without any problem in BIRT ...