• Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB QL question

 
Vili Leonardo
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am trying to create an ejb ql that would retrieve all rows from the database that have client field as specified by user and the PO field is blank.

This is what I try:

SELECT OBJECT(q) FROM QuoteSchema q
WHERE q.client = ?1 and q.PO = ' '

but it does not return any rows back. then I change the query to

SELECT OBJECT(q) FROM QuoteSchema q
WHERE q.client = ?1 and q.PO IS NULL

It also does not return any rows.

Does anyone know how to specify the condition q.PO is blank in EJB QL?

Thanks
-Vili
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!