1 Reply Latest reply on Apr 21, 2002 9:58 AM by Richard Grantham

    EJB-QL Queries

    Richard Grantham Newbie

      I have written a query such that a collection of a person EJB is returned that have manager status. It looks like this:

      SELECT OBJECT(p) FROM person AS p WHERE p.manager = TRUE;

      Given the current data in my database it should return a collection with 1 thing in it. However, I get an empty collection. Is this type of Boolean literal query unsupported currently? That would seem very silly to me, or have I done something stupid? That would be reasonable as it's a nice sunny day and the screaming kids are out screaming. It's driving me a little mental.

      Rilux

        • 1. Re: EJB-QL Queries
          Richard Grantham Newbie

          Well, I seem to be having some major EJB-QL issues. I modified the query I've described above to do the same as an existing and working EJB-QL query - and I still get an empty result set.

          What's more, if I edited this working one to the above it works exactly the same way as it did before being edited.

          What on earth is going on here?

          Rilux