Wouter,
Yes this works. Thank you.
eve
> Date: Mon, 13 Oct 2008 14:09:37 +0200> From: wouter_at_van.reeven.nl> To: persistence_at_glassfish.dev.java.net> Subject: Re: setting two parameters> > 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...?"
_________________________________________________________________
Make a mini you and download it into Windows Live Messenger
http://clk.atdmt.com/UKM/go/111354029/direct/01/