Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 40050 invoked from network); 30 Sep 2005 03:10:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Sep 2005 03:10:43 -0000 Received: (qmail 54838 invoked by uid 500); 30 Sep 2005 03:10:41 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 54765 invoked by uid 500); 30 Sep 2005 03:10:40 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Delivered-To: moderator for user-java@ibatis.apache.org Received: (qmail 33677 invoked by uid 99); 30 Sep 2005 02:28:15 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_WHOIS,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) From: "anton" To: Subject: Question about paginated list. Date: Fri, 30 Sep 2005 09:27:04 +0700 Message-ID: <000001c5c566$76d2a6e0$dd07000a@Sectocom> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C5C5A1.23317EE0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at indoartha.co.id X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C5C5A1.23317EE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, Recently im working with paging feature in my web application, and I need to get a ranged results from a query, lets say that my query will get 10.000 records but I want to get only 10 records from it,(eg starting from record 9.980 until record 9.990), I already know iBATIS paginated list but it doesn't solve my problem since the queryForPaginatedList() method retrieve all the 10.000 records. Does anyone here know how can I achieve that (Hibernate already come with the Query.setFirstResult() and Query.setMaxResult() method to solve this)? Thank You. ------=_NextPart_000_0001_01C5C5A1.23317EE0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

Recently im working with = paging feature in my web application, and I need to get a ranged results from a query, = lets say that my query will get 10.000 records but I want to get only 10 = records from it,(eg = starting from record 9.980 until record 9.990), I already know iBATIS paginated list but it doesn’t solve my problem since the queryForPaginatedList() method retrieve all the = 10.000 records. Does anyone here know how can I achieve that (Hibernate already = come with the Query.setFirstResult() and Query.setMaxResult() method to solve this)? Thank You.

 

 

------=_NextPart_000_0001_01C5C5A1.23317EE0--