My application uses a lot of "manual" paging (using ROWNUM and nested selects in Oracle PL/SQL). For each of these queries there is a second query that returns the total number of results with _identical with-clause_ (sometimes quite complex). Does iBatis offer any help in avoiding these code duplicates?
(Or does anybody know a better way, for example a way to retrieve both the total count and a specific "page" in a single statement?) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
