Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Parameter in "in" SQL clause
Parameter in "in" SQL clause [message #50153] Thu, 23 June 2005 05:37 Go to next message
Eclipse UserFriend
Originally posted by: shiffer_david.caramail.com

Is it possible to use a parameter in a "in" SQL clause, indeed i want to
do the following:

select * from table where id in ( ? )

The parameter should contains a string value like '1,2,3,4' but it doesn't
work, only one of these values is taken.
Anybody tried to use a parameter in this way?
Re: Parameter in "in" SQL clause [message #50334 is a reply to message #50153] Thu, 23 June 2005 09:16 Go to previous message
Eclipse UserFriend
Originally posted by: none.none.com

Hi,

Look for the thread of June 15th in this newsgroup with the subject: How do
I use multiple parameters in BITR?

Thanks,

David


"shiffer_david" <shiffer_david@caramail.com> wrote in message
news:ace57c5bccfe9a801bdfc247f3c0d842$1@www.eclipse.org...
> Is it possible to use a parameter in a "in" SQL clause, indeed i want to
> do the following:
> select * from table where id in ( ? )
> The parameter should contains a string value like '1,2,3,4' but it doesn't
> work, only one of these values is taken.
> Anybody tried to use a parameter in this way?
>
Previous Topic:Missing
Next Topic:errors with flat file
Goto Forum:
  


Current Time: Sat Jul 27 18:29:40 GMT 2024

Powered by FUDForum. Page generated in 0.03263 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top