db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From peter riegersperger <r...@subnet.at>
Subject Re: How to get specified number of entries?
Date Mon, 17 Mar 2003 10:28:11 GMT
-----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 through to
> MySQL and PostgreSQL"
> Maybe somebody using mysql could clarify this?
>
> Andras.

i needed pagination for a query and "next record" and "previous record" 
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 hurry to 
just get it done, so i just worked around it. small application, small 
database, small problem :P

rick


- -- 
|-
| 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
|- 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+daM8IMP39JYOy9IRAuQ1AJ9KUaRYLjkFd/k3tRWuiZWpd3dtZgCgqGs4
RovUWTvmOKsFs3iEQGxOuz4=
=DmAl
-----END PGP SIGNATURE-----


Mime
View raw message