ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <lmead...@apache.org>
Subject Re: Setting the LIMIT in a MYSQL select statement
Date Mon, 31 Oct 2005 20:07:39 GMT
A property on your parameter object.

Larry


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