A-hah!
- Original Message -
From: "Gelhar, Wallace Joseph" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, September 30, 2004 1:51 PM
Subject: RE: Simple DISTINCT query
getCollectionByQuery(q) is not the correct meth
un field, which is a date.
- Original Message -
From: "Robert S. Sfeir" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, September 30, 2004 1:35 PM
Subject: Re: Simple DISTINCT query
> "JDBC]Invalid column name: AMOUNT"
]; OJB Users List
Subject: Re: Simple DISTINCT query
Like this? (This is what failed)
public static Collection getAllBillDates (AuthorizedUser user)
throws PersistenceException, PermissionDeniedException {
Criteria c = new Criteria();
ReportQueryByCriteria q
e)
> at
> org.apache.ojb.broker.util.JdbcTypesHelper$T_Float.readValueFromResultSet(Jd
> bcTypesHelper.java:773)
> at
> org.apache.ojb.broker.util.JdbcTypesHelper$BaseType.getObjectFromColumn(Jdbc
> TypesHelper.java:302)
> at
> org.apache.ojb.broker.util.JdbcTypesHelper$Base
ache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(RowRea
derDefaultImpl.java:199)
... 94 more
So why is it referring to "amount" at all?
- Original Message -
From: "Stijn de Witt" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL
Look at ReportQueries, they are part of the PersistenceBroker interface
and let you perform selects where the result is not a complete object.
-Stijn
Ian Hunter wrote:
I've been pulling my ahir out trying to accomplish something simple. Say I
have a table called FOO, with fields FOOID (int), FOO
I've been pulling my ahir out trying to accomplish something simple. Say I
have a table called FOO, with fields FOOID (int), FOODATE (datetime), and
FOOAMOUNT (double). Some process writes data to this table, where FOOID is
a autoincrement field, FOODATE is a datestamp, for which there can be
dup