http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+reuse+SQL-fragments
On Mon, Nov 23, 2009 at 9:11 AM, Stephen Friedrich <[email protected]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
