Return-Path: 
 <user-java-return-7544-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 94513 invoked from network); 21 Jun 2006 22:57:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 21 Jun 2006 22:57:25 -0000
Received: (qmail 18256 invoked by uid 500); 21 Jun 2006 22:57:23 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 18241 invoked by uid 500); 21 Jun 2006 22:57:23 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 18230 invoked by uid 99); 21 Jun 2006 22:57:22 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 15:57:22 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [130.16.43.23] (HELO ddsmttayz012.ptc.pentagon.mil)
 (130.16.43.23)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 15:57:20 -0700
Received: by ddsmttayz012.ptc.pentagon.mil with Internet Mail Service
 (5.5.2653.19)
	id <NJ7ZQVNS>; Wed, 21 Jun 2006 18:56:59 -0400
Message-ID: <D2909F64E8DF6A4DA12D5D83BFF5D60702BF6DDD@ddsmttayz026>
From: "Yee, Richard K CTR DMDC" <Richard.Yee.ctr@osd.pentagon.mil>
To: "'user-java@ibatis.apache.org'" <user-java@ibatis.apache.org>
Subject: RE: Return result as Map
Date: Wed, 21 Jun 2006 18:56:53 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Try using queryForList instead of queryForMap

-Richard

-----Original Message-----
From: jaybytez [mailto:jaybytez@gmail.com] 
Sent: Wednesday, June 21, 2006 2:51 PM
To: user-java@ibatis.apache.org
Subject: RE: Return result as Map



Here is my query:

  <select id="queryMapFacilityServiceLookup"
resultClass="java.util.HashMap">
    <![CDATA[
      SELECT facility_service_desc, facility_service_code
      FROM facility_service_lookup
    ]]>
  </select> 

And here is how I call it:

Map mappedValues =  sqlMap.queryForMap("queryMapFacilityServiceLookup",
null, "facility_service_desc","facility_service_code");

And i get a Map back with null values and one row.
--
View this message in context:
http://www.nabble.com/Return-result-as-Map-t1824496.html#a4983369
Sent from the iBATIS - User - Java forum at Nabble.com.