Eclipse Community Forums: BIRT » Issue with using the IN clause and parameters

Help

Home

Home » Archived » BIRT » Issue with using the IN clause and parameters

Show: Today's Messages :: Show Polls :: Message Navigator

Issue with using the IN clause and parameters [message #156973]

Thu, 27 April 2006 23:04

Eclipse User

Originally posted by: alfiewong.gmail.com

Select * from runs where id in ( ? )

where ? is set to "20, 35" without the quotes and id is a number data type.

We are trying to run this query in our report but it only returns the
last value "35". We have tried changing the data types but nothing seems
to return both rows in the run table. Furthermore we have only tried
this in the preview mode.

Thank you,
Alfred Wong

Report message to a moderator

Previous Topic:	the last column's values do not show up,the first column's values are replaced by 0, 1, 3, 4 .. is i
Next Topic:	Messge for a blank report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 27 12:53:24 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter