-----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 <[EMAIL PROTECTED]> |- | 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----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
