• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • 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