Hello everyone, How do you convert this: 'select s FROM Staff s where s.id=id and s.pwd=pwd' to something like below: name = "getStafflogin",query = "SELECT s FROM Staff s where UPPER(s.staid) LIKE :param AND UPPER(s.password) LIKE :param 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.
eve
_________________________________________________________________
Get all your favourite content with the slick new MSN Toolbar - FREE
http://clk.atdmt.com/UKM/go/111354027/direct/01/