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

[Mohammed Mudassir]

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)