Re: EOF & DB Aggregation functions

I've tried defining a fetch spec with "custom sql".  However, EOF  
appears to have great trouble with it, every time I click back the  
SQL is back to the generated sql.  Perhaps I should just edit the  
fspec file with vi.

On Oct 22, 2006, at 12:17 PM, Paul Lynch wrote:

> On 22 Oct 2006, at 15:31, Randy Wigginton wrote:
>
>> 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?
>
> You can define a named query that uses raw sql.
>
> Paul
>