You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Hamza Rana <Ha...@esstec.com.pk> on 2002/01/04 11:47:42 UTC

Trouble with LIMIT in CRITERIA, any solution ???

Hi , 
the result return after calling doSelect(Criteria ) has no impact when i
apply setOffset() and setLimit() to its criteria. Does ne one knwo ne
work out to it?
here is the code i m using
	  Business myBiz = new Business();
      Criteria crit= new Criteria();
      crit.setLimit(2);
      crit.setOffset(2);

      try{
      Vector v  = (Vector)BusinessPeer.doSelect(crit);
      System.out.println(v.size());
	}
and its printing 4..:O
please help me out in this problem. although when i call crit.toString()
it gives
Current Query SQL (may not be complete or applicable): SELECT  FROM
LIMIT 2, 2
Thanks in advance....

regards
Hamza 

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>