Re: EOF & DB Aggregation functions
"Watkins, Garry" <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <C1610069.80E0%[email protected]> |
You can define and model a view. -- Garry Watkins Database Administrator Motley Rice LLC 843-216-9639 > From: Randy Wigginton <[email protected]> > Date: Sun, 22 Oct 2006 07:31:56 -0700 > To: <[email protected]> > Subject: EOF & DB Aggregation functions > > I've done a number of internet searches and cannot seem to find any > information, though I thought I had read something about this... > > I need to perform an operation something like this: > select sum(time), sum(counter), max(time) from mytable where key1=? > and key2=? > > > Is there a "nice" way to do this, other than rawRowsForSql? And if > rawRowsForSQL is the only option, is there a way to perform a bind, > rather than building the sql string dynamically? > > _______________________________________________ > WebObjects-dev mailing list > [email protected] > http://www.omnigroup.com/mailman/listinfo/webobjects-dev Confidential & Privileged Unless otherwise indicated or obvious from its nature, the information contained in this communication is attorney-client privileged and confidential information/work product. This communication is intended for the use of the individual or entity named above. If the reader of this communication is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error or are not sure whether it is privileged, please immediately notify us by return e-mail and destroy any copies--electronic, paper or otherwise--which you may have of this communication.