Re: BigDecimal for SELECT SUM(...)
Re: BigDecimal for SELECT SUM(...)
- Subject: Re: BigDecimal for SELECT SUM(...)
- From: Chuck Hill <email@hidden>
- Date: Thu, 25 Sep 2008 11:40:48 -0700
On Sep 25, 2008, at 10:51 AM, Henrique Prange wrote:
Hi all,
I'm trying to get the sum of a decimal column executing a query like
that:
SELECT SUM( field ) FROM table...
The query execution returns a value of type Long, but I need a value
of type BigDecimal. Is there a way to specify the expected returning
value type?
I'm using ERXEOAccessUtilities.rawRowsForSQLExpression to execute
the query.
I'd try one of the ERXEOControlUtilities
aggregateFunctionWithQualifier methods, if you can find one that
works. They take an attribute, so should be able to return the
correct type.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden