Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 91791 invoked from network); 12 Apr 2006 14:59:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 12 Apr 2006 14:59:36 -0000 Received: (qmail 7023 invoked by uid 500); 12 Apr 2006 14:59:33 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 7004 invoked by uid 500); 12 Apr 2006 14:59:33 -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 Received: (qmail 6992 invoked by uid 99); 12 Apr 2006 14:59:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Apr 2006 07:59:33 -0700 X-ASF-Spam-Status: No, hits=1.6 required=10.0 tests=DEAR_SOMETHING,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com designates 66.249.82.203 as permitted sender) Received: from [66.249.82.203] (HELO xproxy.gmail.com) (66.249.82.203) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Apr 2006 07:59:32 -0700 Received: by xproxy.gmail.com with SMTP id i31so1007608wxd for ; Wed, 12 Apr 2006 07:59:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WC3AzTxqzbvBqH2phg23RLsotKqoebkGvyiJd9iSOpqOlmvL5ZbigTChENrtTtOFgRQ/2wX4Ilt0P8EXj3A8HDKe9483pGMh9g1AJS9gjxHCtyz9A7dHcjfpYVoKvNZcUPi61TO5Fyn0/rrE+a+h/rFAcyFotkJ+LxCbSTF1JKU= Received: by 10.70.92.11 with SMTP id p11mr1130696wxb; Wed, 12 Apr 2006 07:59:12 -0700 (PDT) Received: by 10.70.76.11 with HTTP; Wed, 12 Apr 2006 07:59:12 -0700 (PDT) Message-ID: Date: Wed, 12 Apr 2006 08:59:12 -0600 From: "Larry Meadors" Reply-To: lmeadors@apache.org Sender: larry.meadors@gmail.com To: user-java@ibatis.apache.org Subject: Re: pager in ibatis In-Reply-To: <443D1487.7030606@ncmail.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <2E7899FA2A83AB4480078DA88C8F10FBE44EC5@HYD-MDP-MBX01.wipro.com> <443D1487.7030606@ncmail.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N queryForPaginatedList() Larry On 4/12/06, John Chien wrote: > Dear sir: > > I have a feature that requires me to return query result of a selection > statment in certain amount of successive records every time. > This is just like a page. > > For example: > > SELECT id, name > FROM employee; > > The selection result of this statement is a list. > However, I want to only get 30 records every time. > For the first call, I want to get the first 30 (1 - 30) records, for > thext call, I would like to get the next 30 (31 - 60) records. > > How can I do this in Ibatis ? > > Thanks, > > John Chien > > >