I have tried to use
select count(distinct o.id) from com.... o where....
but it doesn't work in castor, because OQL parser can not recgonize the
count and distinct together.
I am not sure about the syntax, is there a a OQL query to do use both the
count and the distinct?
Thanks,
John W
----- Original Message -----
From: "Bruce Snyder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 2:35 PM
Subject: Re: [castor-dev] size of resultset returned from castor
> > Matthew Baird wrote:
> >
> > Is there a quick way to get the size of the resultset enumeration
> > returned by castor without having to iterate through all elements?
> >
> > if not, this seems like it would be a great feature. Another feature
> > that would be great to go along with this would be the ability to
> > iterate through the resultset without actually materializing an
> > object, somewhat of a .skip() or .skip(amount) call.
> >
> > thoughts?
>
> Matthew,
>
> Unfortunately there is no easy way of grabbing the size of a
> QueryResults ResultSet. That would be a very nice feature.
>
> This second type of functionality would also be incredibly nice and can
> be accomplished through the use of Proxy Objects. However, this is not
> currently supported. The amount of work to implement such a thing is
> rather
> difficult to determine because it reaches much further than you think.
>
> May they'll both be supported in the future.
>
> Bruce
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
