ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kambix <kambiz.tavak...@mgm-tp.com>
Subject Re: select multiple fields query
Date Thu, 09 Jul 2009 18:13:05 GMT

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."
> 
> 

-- 
View this message in context: http://www.nabble.com/select-multiple-fields-query-tp16810325p24415042.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message