[Seaside] ROE, anyone?
benjamin.pollack at gmail.com
Thu Jan 5 06:57:45 CET 2006
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.
More information about the Seaside