Re: EOF & DB Aggregation functions

Oh, that happens to other people, does it? :-(

Yes, you should manually edit the fspec.  I think I stumbled across  
some click combination that let me save it from EOModeler, but I  
couldn't guarantee to reproduce it.

Paul

On 22 Oct 2006, at 21:06, Randy Wigginton wrote:

> 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
>>
>
>