Try using
query.setStartAtIndex(0);
query.setEndAtIndex(10);
Ron Gallagher
Atlanta, GA
[EMAIL PROTECTED]
>
> From: "Ismail Siddiqui" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed PM 02:26:35 EST
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Subject: Selecting Top 10 records??
>
> Hi all
> I am using QueryByCriteria as following
>
> PersistenceBroker broker =
> PersistenceBrokerFactory.defaultPersistenceBroker();
> broker.beginTransaction();
> Criteria c = new Criteria();
> c.addEqualToColumn("program_instance_id", program_instance_id+"");
> c.addOrderByDescending("score");
> QueryByCriteria query = new QueryByCriteria(Game.class, c);
> Collection game =
> broker.getCollectionByQuery(query);
>
> I am running microsoft sql server and want to select only top 5 records
> ..like select top 5 * where .... How can I put this condition in Criteria
>
>
> Thanks
>
> ismail
>
>
> ---------------------------------------------------------------------
> 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]
