Two Statement and Two Result Map - One ResultMap not found?

[Mohammed Mudassir <mm...@gmail.com>]

Hello Guys,

I made the proc work and it was cool ! thanks for your help, now the
thing is i want the "Seelct" statement and yes also the "Proc" all
together.

I am getting the following error: 
Exception Details:
IBatisNet.DataMapper.Exceptions.DataMapperException: This SQL map does
not contain a MappedStatement named SelectCity


and here is my SQLMap.xml


<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="IbatisBuraq.WebFaceSQL"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SqlMap.xsd">
	<!-- XML "behind" document for the People service class. -->
	<alias>
		<typeAlias alias="Publishers" type="IbatisBuraq.WebFaceSQL.Publishers" />
		<typeAlias alias="Cities" type="IbatisBuraq.WebFaceSQL.Cities" />
	</alias>
	<resultMaps>
		<resultMap id="SelectCity" class="Cities">
			<result property="City" column="City"></result>
		</resultMap>
		<resultMap id="SelectSPResult" class="Publishers">
			<result property="Name" column="Name" />
			<result property="CompanyName" column="Company Name" />
			<result property="Address" column="Address" />
			<result property="City" column="City" />
			<result property="State" column="State" />
		</resultMap>
	</resultMaps>
	<statements>
		<select id="select-cities" class="Cities" resultMap="SelectCity">
			Select Distinct City 
			FROM Publishers
			WHERE City IS NOT NULL
		</select>
		<procedure id="GetPublisher" resultMap="SelectSPResult" parameterMap
= "ParamMap" Class="Publishers">
			la_GetPublisher
		</procedure>
	</statements>
	
<parameterMaps>
	<parameterMap id="ParamMap" class="ParamMap">
		<parameter property="paramCity" />
	</parameterMap>
</parameterMaps>

</sqlMap>

Take Care,

-- 

Mudassir

San Jose,CA

--------------------------------------------------------------------------------------------------------------------------

Hope is a good thing, maybe the best of things, and no good thing ever dies. 

- The Shawshank Redemption (Movie)

Re: Two Statement and Two Result Map - One ResultMap not found?

[Roberto R <ro...@gmail.com>]

It looks like it's called "select-cities".

On 6/5/05, Mohammed Mudassir <mm...@gmail.com> wrote:
> 
> Hello Guys,
> 
> I made the proc work and it was cool ! thanks for your help, now the
> thing is i want the "Seelct" statement and yes also the "Proc" all
> together.
> 
> I am getting the following error:
> Exception Details:
> IBatisNet.DataMapper.Exceptions.DataMapperException: This SQL map does
> not contain a MappedStatement named SelectCity
> 
>