Re: Whats the recommended way for cross-object information inquiry?
Re: Whats the recommended way for cross-object information inquiry?
- Subject: Re: Whats the recommended way for cross-object information inquiry?
- From: "Jonathan 'Wolf' Rentzsch" <email@hidden>
- Date: Tue, 9 Mar 2004 16:57:17 -0600
Jonathan Rochkind, email@hidden, wrote:
>Yeah, but in this case... did you see the SQL he wanted to use? I'm
>not sure there's any good way to get that SQL out of a
>qualifier/fetch spec. If there is.... then someone suggest it!
It was:
>SELECT YEAR, count(*) FROM PERSONS_TABLE GROUP BY YEAR ORDER BY
>YEAR;
Ah, good point. I missed the counting and 'GROUP BY'.
Project WONDER has some GROUP BY support (see ERXToManyQualifier and
DynaReporter). I don't know if this is a complete fit as I haven't needed
it myself.
If you just want to count rows instead of returning them, that requires
some nonobvious code:
<http://www.omnigroup.com/mailman/archive/webobjects-dev/2002-April/022359.
html>
| Jonathan 'Wolf' Rentzsch http://rentzsch.com
| Red Shed Software http://redshed.net
| "better" necessarily means "different"
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.