Hello Larry,
in the above example; can I get only the second column back with resultClass="String"
without resultmap? I mean how can I map it?
I have a group by query with more than one column, but only one of them is to be mapped
(the first one in this case). How can I do it whithout defining a class for it?
<select id="Chk_Vordruck" resultClass="String">
SELECT formular_vordruck_name AS Vordruck_Name,
Formular_UFA AS Unterfallart,
MIN(formular_jahr) AS min_jahr,
MAX(formular_jahr) AS max_jahr
FROM Formular
GROUP BY formular_vordruck_name,
Formular_UFA
</select>
thank you
regards
kambiz
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@ieee.org> 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@ieee.org
>
> "The cruellest lies are often told in silence."
