Monday, July 12, 2004 03:46 PM
Now let me answer my question. Yes, it is possible to fetch data from MySQL using the LIMIT clause.
'SELECT ... FROM ... LIMIT start, size', where start is the position of the first database record (eg 0) and size is the size of the page (eg 20).
To bad for me I can't use it from a CMP entity because CMP 2.0 (even 2.1) can't manage it(Error compiling EJB-QL statement) :(:(
Any idea is welcome (before I start using BMP instead).