Re: select multiple fields query

> Thanks, it works nice :)
> I notice the Map's keys are always strings in uppercase. Is it possible to
> control the case?
>
> cheers
>
>
>
> On Mon, Apr 21, 2008 at 3:59 PM, Larry Meadors <larry.meadors@...>
> wrote:
>
> > You can't currently get a list of lists, but you can get a list of maps:
> >
> > <select id="getClusterNames" resultClass="hashmap">
> >
> > Larry
> >
> >
> >
> >
> >
> > On Mon, Apr 21, 2008 at 7:21 AM, Filipe David Manana <fdmanana@...>
> wrote:
> > > Hi,
> > >
> > > I am a beginner regarding iBATIS (Java version). I want to map a select
> > > query that returns rows of 2 fields. My sql map is:
> > >
> > >   <select id="getClusterNames" resultClass="String">
> > >      SELECT DISTINCT clustername, clustertype
> > >     FROM vwhost
> > >   </select>
> > >
> > > Using this mapping I get a List of Strings, but only values for the
> > > clustername field.
> > > I would like to get, for example, a List of Lists (each inner list would
> > > have exactly 2 strings).
> > >  Using "List" as the resultClass I get a List of empty Lists :(
> > > How can I get the 2 columns?
> > >
> > > cheers
> > >
> > > --
> > > Filipe David Manana,
> > > fdmanana@...
> > >
> > >  "The cruellest lies are often told in silence."
> >
>
>
>
> --
>
> Filipe David Manana,
> fdmanana@...
>
> "The cruellest lies are often told in silence."