Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Content-Type: text/plain;
  charset="iso-8859-1"
From: peter riegersperger <rick@subnet.at>
Organization: subnet
To: "Turbine Torque Users List" <torque-user@db.apache.org>
Subject: Re: How to get specified number of entries?
Date: Mon, 17 Mar 2003 11:28:11 +0100
User-Agent: KMail/1.4.3
References: <005801c2ebbc$c5ca1750$f9c3e6d9@yomama>
 <200303171055.39716.rick@subnet.at>
 <013701c2ec6c$52c8a720$0200a8c0@ms.reea.net>
In-Reply-To: <013701c2ec6c$52c8a720$0200a8c0@ms.reea.net>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200303171128.12186.rick@subnet.at>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 17 March 2003 11:02, Andras Balogh wrote:
> >limit never worked for me (on mysql). it didn't get written into the
> >sql-statement.
> >but ymmv of course.
> >
> >rick
>
> Strange,
> Even the javadocs of LargeSelect states that it should work:
> "At time of writing Criteria will only pass the offset and limit throug=
h to
> MySQL and PostgreSQL"
> Maybe somebody using mysql could clarify this?
>
> Andras.

i needed pagination for a query and "next record" and "previous record"=20
information, so i tried to use a select with LIMIT 1.
honestly, i didn't try if some other value works, because i was in a hurr=
y to=20
just get it done, so i just worked around it. small application, small=20
database, small problem :P

rick


- --=20
|-
| peter riegersperger  <rick@subnet.at>
|-
| subnet
| platform for media art and experimental technologies
|-
| http://www.subnet.at/
|-
| muehlbacherhofweg 5 // 5020 salzburg // austria
|-
| fon/fax +43/662/842 897
|-=20
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+daM8IMP39JYOy9IRAuQ1AJ9KUaRYLjkFd/k3tRWuiZWpd3dtZgCgqGs4
RovUWTvmOKsFs3iEQGxOuz4=3D
=3DDmAl
-----END PGP SIGNATURE-----