[Seaside] ROE, anyone?

[Benjamin Pollack]

On 1/3/06, Brian Brown <rbb at techgame.net> wrote:
> After a 6 month hiatus, I'm back doing some seaside work, and am
> using ROE to access a preexistent database. I have a need to be able
> to select records based on the month and the year in a datetime
> field, but there doesn't seem to be any way to use SQL functions such
> as SUM(), MAX(), MONTH(), YEAR(), etc....  I tried to figure out how
> to add something like that, but failed quite miserably!
>
> Anyone have any thoughts, ideas, pointers, etc.?

The last time I was in a similar situation, I simply made a view with
SUM(), etc. as columns. If some of the columns are not derived data
and you need to be able to issue UPDATEs, you can attach a trigger to
the UPDATE action that ignores the derived columns.

--Benjamin