Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 8751 invoked from network); 21 Jul 2006 20:03:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Jul 2006 20:03:22 -0000 Received: (qmail 2238 invoked by uid 500); 21 Jul 2006 20:03:21 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 2221 invoked by uid 500); 21 Jul 2006 20:03:21 -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 2210 invoked by uid 99); 21 Jul 2006 20:03:21 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Jul 2006 13:03:21 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_MESSAGE,HTML_TAG_EXIST_TBODY,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Jul 2006 13:03:19 -0700 Received: from fe-amer-03.sun.com ([192.18.108.177]) by brmea-mail-3.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k6LK2wW3003424 for ; Fri, 21 Jul 2006 14:02:58 -0600 (MDT) Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J2R00701RLHX300@mail-amer.sun.com> (original mail from Nathan.Maves@Sun.COM) for user-java@ibatis.apache.org; Fri, 21 Jul 2006 14:02:58 -0600 (MDT) Received: from [129.147.48.196] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J2R00C7EROYKIA1@mail-amer.sun.com> for user-java@ibatis.apache.org; Fri, 21 Jul 2006 14:02:58 -0600 (MDT) Date: Fri, 21 Jul 2006 14:04:24 -0600 From: Nathan Maves Subject: Re: Urgent help needed -- queryForList() problem In-reply-to: <2E7899FA2A83AB4480078DA88C8F10FB019A6576@HYD-MDP-MBX01.wipro.com> Sender: Nathan.Maves@Sun.COM To: user-java@ibatis.apache.org Message-id: MIME-version: 1.0 X-Mailer: Apple Mail (2.752.2) Content-type: multipart/alternative; boundary="Boundary_(ID_6UJMIPRipLI1ZgxfCUZ8bA)" References: <2E7899FA2A83AB4480078DA88C8F10FB019A6576@HYD-MDP-MBX01.wipro.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Boundary_(ID_6UJMIPRipLI1ZgxfCUZ8bA) Content-type: text/plain; format=flowed; delsp=yes; charset=US-ASCII Content-transfer-encoding: 7BIT Could use please post your sqlMap query and result map. On Jul 21, 2006, at 9:57 AM, rambabu.piridi@wipro.com wrote: > > > Hi, > > In my application I am using Ibatis as datamapper and firebird > as the backend. > > In my database, I have 10 records and I want to get first 5 of them. > > Here I am using > sqlMap.queryForList("getUsersList", null, 0, 5) to retrive > the first 5 records from the database. > > But the query is fetching only 3 records. > > When I give the boundaries as (0,7) - it is fetching 4 records only. > > but my requirenment is to get the records in between the specified > boundaries. i.e, if boundary is specified as (0,7) it should > retrieve 7 records, starting from 0. > > I am unable to find the problem? Can any one help me in this regard? > > > Thanks n Regards, > ============== > Rambabu Piridi. > > > The information contained in this electronic message and any > attachments to this message are intended for the exclusive use of > the addressee(s) and may contain proprietary, confidential or > privileged information. If you are not the intended recipient, you > should not disseminate, distribute or copy this e-mail. Please > notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The > recipient should check this email and any attachments for the > presence of viruses. The company accepts no liability for any > damage caused by any virus transmitted by this email. > > www.wipro.com --Boundary_(ID_6UJMIPRipLI1ZgxfCUZ8bA) Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: QUOTED-PRINTABLE Could use please post your sq= lMap query and result map.

=
=A0
On Jul 21, 2006, at 9:57 AM, rambabu.piridi@wipro.com wrote:
=A0
=A0
Hi,
=A0
=A0= =A0 In my application I am using Ibatis as datamapper and= firebird as the backend.
=A0
In my database, I have 10 records and I want to get first=A05 = of them.
= =A0
Here I am = using
=A0=A0=A0=A0=A0=A0=A0=A0 sqlMap.queryFo= rList("getUsersList", null, 0, 5)=A0to retrive the first= =A05 records from the database.=A0
=A0
=A0But the query is fetching only=A03 records.=
=A0
When I give the boundarie= s as (0,7) - it is fetching 4 records only.
= =A0
but my requirenment is to get the records in= between the specified boundaries. i.e, if boundary is specified as (= 0,7) it should retrieve 7 records, starting from 0.
=A0
I am unable to find = the problem? Can any one help me in this regard?
=
= =A0
=A0
=
Thanks n Regards,
=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
Rambabu Piridi.
=
=A0
<= TR>

The informati= on contained in this electronic message and any attachments to this m= essage are intended for the exclusive use of the addressee(s) and may= contain proprietary, confidential or privileged information. If you = are not the intended recipient, you should not disseminate, distribut= e or copy this e-mail. Please notify the sender immediately and destr= oy all copies of this message and any attachments.

WARNING:= Computer viruses can be transmitted via email. The recipient should = check this email and any attachments for the presence of viruses. The= company accepts no liability for any damage caused by any virus tran= smitted by this email.

www.= wipro.com

--Boundary_(ID_6UJMIPRipLI1ZgxfCUZ8bA)--