Return-Path: 
 <user-java-return-4751-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 35847 invoked from network); 31 Oct 2005 19:44:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 31 Oct 2005 19:44:26 -0000
Received: (qmail 60802 invoked by uid 500); 31 Oct 2005 19:44:25 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 60684 invoked by uid 500); 31 Oct 2005 19:44:24 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 60673 invoked by uid 99); 31 Oct 2005 19:44:24 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Oct 2005 11:44:24 -0800
X-ASF-Spam-Status: No, hits=0.6 required=10.0
	tests=NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [168.159.2.31] (HELO mailhub.lss.emc.com) (168.159.2.31)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Oct 2005 11:44:20 -0800
Received: from mxic2.corp.emc.com (mxic2.corp.emc.com [128.221.12.9])
	by mailhub.lss.emc.com (Switch-3.1.6/Switch-3.1.6) with ESMTP id
 j9VJi0t5018321
	for <user-java@ibatis.apache.org>; Mon, 31 Oct 2005 14:44:00 -0500 (EST)
Received: by mxic2.corp.emc.com with Internet Mail Service (5.5.2653.19)
	id <RT6C2LAW>; Mon, 31 Oct 2005 14:44:00 -0500
Message-ID: <BD0E0E16080D59438375C600B086CFFAFB779F@CORPUSMX20B.corp.emc.com>
From: Rajah_Mithra@emc.com
To: user-java@ibatis.apache.org
Subject: Setting the LIMIT in a MYSQL select statement
Date: Mon, 31 Oct 2005 14:43:53 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain
X-PMX-Version: 4.7.1.128075, Antispam-Engine: 2.1.0.0,
 Antispam-Data: 2005.10.31.21
X-PerlMx-Spam: Gauge=, SPAM=1%, Reasons='EMC_FROM_00+ -3, NO_REAL_NAME 0,
 __CT 0, __CT_TEXT_PLAIN 0, __HAS_MSGID 0, __HAS_X_MAILER 0, __IMS_MSGID 0,
 __IMS_MUA 0, __MIME_TEXT_ONLY 0, __MIME_VERSION 0, __SANE_MSGID 0'
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


Hi,

Is there any way to dynamically alter the LIMIT clause in Mysql with IBATIS?

Say for ex,

Select * from User LIMIT #row_number#, 1;

To get a particular row from the table.

Thanks,

Mithra Rajah