Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: BigDecimal for SELECT SUM(...)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: BigDecimal for SELECT SUM(...)

Subject: Re: BigDecimal for SELECT SUM(...)
From: Henrique Prange <email@hidden>
Date: Thu, 25 Sep 2008 17:06:46 -0300

Thanks Chuck! The source code of those methods helped me to find a solution.

Cheers,

Henrique

Chuck Hill wrote:

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

_______________________________________________
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



References:  
  >BigDecimal for SELECT SUM(...) (From: Henrique Prange <email@hidden>)
  >Re: BigDecimal for SELECT SUM(...) (From: Chuck Hill <email@hidden>)




Prev by Date:
Re: Cloning objects in WO?

Next by Date:
Re: ec.deleteObject() and NSValidationErrors caused by the delete

Previous by thread:
Re: BigDecimal for SELECT SUM(...)

Next by thread:
ec.deleteObject() and NSValidationErrors caused by the delete

Index(es):

Date
Thread