• Post Reply Bookmark Topic Watch Topic
  • New Topic

Basic question about ejb-ql query  RSS feed

 
Albert Steed
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am running into the following problem:
One of the parameters of my finder method is a collection. Here is my finder method:

The behavior I want to achieve is as follows:
-A collection of postcodes comme from the web tier e.g. (75001, 75004 and 75019)
-The search should return all ejbs whose postcodes are either 75001, 75004 or 75019
In java I would have a loop appending strings such as:

How would this translate into ejb-ql?
Thanks in advance,
Albert Steed
[ May 02, 2004: Message edited by: Albert Steed ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 37181
515
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Albert,
Ejb-ql doesn't let you use variable length statements like the one you described. You would have to loop through each entry in the list calling a finder each time.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!