| Author |
Useing IN clause in named/native query
|
pax smith
Ranch Hand
Joined: Dec 13, 2005
Posts: 45
|
|
|
I have created a query and have used 'IN' clause in it. But when I passed pamater "2,3" it is giving me error. Can anybody give any example in which he/she have used 'IN' clause.
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26168
|
|
Pax,
You need to know the number of parameters in advance to use "?" binding variables. The alternative is to query objects one (or a fixed bunch) at a time or build the query at runtime.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
pax smith
Ranch Hand
Joined: Dec 13, 2005
Posts: 45
|
|
I don't decide the no. of parameters in advance it is decided at runtime.
I don't want to append it in the query, is there any way to pass values it as parameter
|
|
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26168
|
|
pax smith wrote:I don't want to append it in the query, is there any way to pass values it as parameter
No.
|
|
 |
|
|
subject: Useing IN clause in named/native query
|
|
|
0
