ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajah_Mit...@emc.com
Subject RE: Setting the LIMIT in a MYSQL select statement
Date Mon, 31 Oct 2005 20:05:00 GMT

Is $row_number$ a string, or a bean member?


Mithra Rajah


-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf Of
Larry Meadors
Sent: Monday, October 31, 2005 3:02 PM
To: user-java@ibatis.apache.org
Subject: Re: Setting the LIMIT in a MYSQL select statement

Select * from User LIMIT $row_number$, 1;

On 10/31/05, Rajah_Mithra@emc.com <Rajah_Mithra@emc.com> wrote:
>
> 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
>
>
>

Mime
View raw message