Thx a million! -----Original Message----- From: Charles N. Harvey III [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 12:04 PM To: OJB Users List Subject: Re: how to count size of resultset in OJB
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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]