From: Wouter van Reeven <wouter_at_van.reeven.nl>
Date: Fri, 4 May 2007 16:56:38 +0200

Hi Eve,

On Fri, May 04, 2007 at 03:44:37PM +0100, Eve Pokua wrote:
> @NamedQuery(name = "GetItemsbydescption",query = "SELECT i FROM
> Iteamdetailsent i WHERE i.description= :description i.itmid=:itmid Or
> i.itmname=:itmname"),

Shouldn't that be

@NamedQuery(name = "GetItemsbydescption",query = "SELECT i FROM
Iteamdetailsent i WHERE i.description= :description or i.itmid=:itmid Or
i.itmname=:itmname")

so another OR in between :description and i.itmid?


HTH, Wouter van Reeven

-- 
People: "If she weighs the same as a Duck, she's made of wood!"
Sir Bedevere: "And therefore...?"