Re: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Anoop kumar V
-- > *From:* Anoop kumar V [mailto:anoopkum...@gmail.com] > *Sent:* Monday, August 24, 2009 10:07 AM > *To:* user-java@ibatis.apache.org > *Subject:* Re: Execute multiple statements (pagination query port from > oracle to mysql) > > Those are not quotes in the sql, those ar

RE: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Poitras Christian
ugust 24, 2009 10:16 AM To: 'user-java@ibatis.apache.org' Subject: RE: Execute multiple statements (pagination query port from oracle to mysql) Oups... read a little to fast... I am not sure if this type of syntax is supported... You should look more into MySQ

RE: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Poitras Christian
: Re: Execute multiple statements (pagination query port from oracle to mysql) Those are not quotes in the sql, those are the quotes required for the string identifier. My question is how can one use such multiple statements within the ibatis sqlmap: set @sql = concat( "s

Re: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Anoop kumar V
; > -Original Message- > From: Anoop kumar V [mailto:anoopkum...@gmail.com] > Sent: Monday, August 24, 2009 9:13 AM > To: user-java@ibatis.apache.org > Subject: Re: Execute multiple statements (pagination query port from oracle > to mysql) > > Anyone? Please help. > > On 8/2

RE: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Poitras Christian
e.org Subject: Re: Execute multiple statements (pagination query port from oracle to mysql) Anyone? Please help. On 8/21/09, Anoop kumar V wrote: > This is an attempt to convert the pagination query using rownum in > Oracle to an equivalent pagination query using limit in mysql. > > I

Re: Execute multiple statements (pagination query port from oracle to mysql)

2009-08-24 Thread Anoop kumar V
Anyone? Please help. On 8/21/09, Anoop kumar V wrote: > This is an attempt to convert the pagination query using rownum in Oracle > to > an equivalent pagination query using limit in mysql. > > I have an existing application that uses an Oracle database in production. > I > am trying to run the s

Execute multiple statements (pagination query port from oracle to mysql)

2009-08-21 Thread Anoop kumar V
This is an attempt to convert the pagination query using rownum in Oracle to an equivalent pagination query using limit in mysql. I have an existing application that uses an Oracle database in production. I am trying to run the same application using mysql on my laptop. The entire application and