Sorry, I should have been more specific. I think my sql is fine. I'm getting two resultsets back from sql server, but only one from queryForList. The list that comes back has both accounts and categories objects in it rather than a list with two elements ( a list of accounts and a list of categories). Looking at the code, a single arraylist is created outside the loop of resultsets and then all the objects from both sql resultsets are added to the same list.
Mike On 6/12/08, Ron Grabowski <[EMAIL PROTECTED]> wrote: > > Try putting a semi-colon after the first select? > > ----- Original Message ---- > From: Michael Schall <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, June 12, 2008 5:46:34 PM > Subject: Multiple ResultMap Support > > I'm trying to use the multiple resultset support in one of my maps. I only > receive one list of objects back. I expected a list of lists back. Is the > following supported somehow? If not I suppose I could loop through and > split the list by type myself. > > Thanks > > Mike > > <select id="GetMultipleResultMap" resultMap="account, category"> > > select * from accounts > > select * from categories > > </select> > > IList list = sqlMap.QueryForList("GetMultipleResultMap", null); > > IList<Account> accountList = list[0]; > > IList<Category> categoryList = list[1]; > > >
