It is about GROUP BY. You can't do it with either EJB- nor JBoss-QL at
the moment.
Darren Hartford wrote:
Hey all,
I got an interesting problem that I should think some of you may have already come
across in some fashion or another. I want to do a search to return a collection of
objects,
Doesn't 'ORDER BY' help you?
Darren Hartford [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
[JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?
Hey all,
I got an interesting problem that I
] Challenge for EJB-QL, JBossQL, or declared
SQL?
Doesn't 'ORDER BY' help you?
Darren Hartford [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/05/2003 04:10 PM
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
[JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL
]
To
[EMAIL PROTECTED]
cc
Subject
RE: [JBoss-user] Challenge for EJB-QL, JBossQL, or declared SQL?
I am not sure ORDER BY is allowed (what about caching then?)
I know EJB QL does not allow that. Maybe JBoss QL.
Regards,
Stephane
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Hey all,
I got an interesting problem that I should think some of you may have already come
across in some fashion or another. I want to do a search to return a collection of
objects, but it needs to be very specific as follows:
Example table:
batchnumber | sequence | receive_date | town |