I need two different resultmaps/resultclass. One resultclass is an "int" for when I do a select count(*). The second is a resultmap for the actual query.
The query is being filtered (using various where clauses). I need to reuse this sql fragment for the paging with filtering as well as the count(*) so I can have this info for my web page. I also need to do this for a lot of queries. I have a reusable count sql fragment and paging fragment, and I could just write my sql and then for each sql have a count and paging which includes my fragments. Though what I would like to do, is in my DAO, to pass in a single statement id, though have a findCount and a findPaging which both take in the sql id to be executed, though includes the appropiate header as well as sets the appropiate result class. Is this possible? Thanks, Josh
