Re: how to count size of resultset in OJB

[Charles N. Harvey III]

This works for me.

-----------------------------------------------------------
       PersistenceBroker broker = null;
       try
       {
           broker = this.getPersistenceBroker();
           return new Integer( broker.getCount( query ) );
       }
       catch( Throwable e )
       {
           throw new OJBRepositoryException( e );
       }
       finally
       {
           this.releasePersistenceBroker( broker );
       }
-----------------------------------------------------------

Charlie

Zhou, Andrew said the following on 5/20/2004 11:56 AM:

Hi guys,

I guess this question has been asked by many people.

Basically, I'd like get the count(*) from query, that way, I can give
user an option if or not user want retrieve everything back.

I am wondering if there is any dicussion on this topic before. I'd
really appreciate if anyone can give some advice.

Thanks
-Andrew

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]