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

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

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

Thu, 27 April 2006 19: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

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 [=-

Current Time: Fri Jul 25 15:31:29 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter