On Mon, Oct 13, 2008 at 01:06:21PM +0100, Eve Pokua wrote:
> and how do you set the parameter:
>
> staffrem= (List<Staffrem>)em.createNamedQuery("getStafflogin").setParameter
> ("param", param.toUpperCase()).getResultList()
>
> I need to provide the setParameter with two different Strings as in the sql
> above. How do I do this
> is JQL?
>
> Your help would greatly be appreciated.
staffrem= (List<Staffrem>)em.createNamedQuery("getStafflogin").setParameter
("param", param.toUpperCase()).setParameter("param2", param2.toUpperCase()).getResultList()
In other words, you can concatenate setParameter multiple times.
HTH, Wouter van Reeven
--
People: "If she weighs the same as a Duck, she's made of wood!"
Sir Bedevere: "And therefore...?"