Return-Path: 
 <dev-return-4886-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 75161 invoked from network); 2 Jun 2009 19:27:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 2 Jun 2009 19:27:47 -0000
Received: (qmail 88614 invoked by uid 500); 2 Jun 2009 19:27:59 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 88571 invoked by uid 500); 2 Jun 2009 19:27:59 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 88563 invoked by uid 99); 2 Jun 2009 19:27:59 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2009 19:27:59 +0000
X-ASF-Spam-Status: No, hits=1.1 required=10.0
	tests=FORGED_HOTMAIL_RCVD2,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2009 19:27:50 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1MBZdx-000444-H3
	for dev@ibatis.apache.org; Tue, 02 Jun 2009 12:27:29 -0700
Message-ID: <23839118.post@talk.nabble.com>
Date: Tue, 2 Jun 2009 12:27:29 -0700 (PDT)
From: sanjeev40084 <sanjeev40084@hotmail.com>
To: dev@ibatis.apache.org
Subject: sql in sqlMap
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: sanjeev40084@hotmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


I am having problem with the sql inside my sqlMap, could anyone help me fix
it.

I have a class to map parameters:

EmployeeParticipants

  public class EmployeeParticipants

  {
        public string EmployeeID { get; set; }
        public int Year              { get; set; }
        public string StartDate   { get; set; }
        public string EndDate     { get; set; }

        public ParticipantParameters(string employeeID, int Year)
        {
            EmployeeID = employeeID;
            Year = Year;
            StartDate = "1/1/" + Year.ToString();
            EndDate = "1/1/" + (Year + 1).ToString();
        }
    }


My sqlMap.xml looks like this,

<alias>
		<typeAlias alias="ParticipantParameters"
type="Quad.QuadMed.QMedAwardPayoutCalculator.Domain.ParticipantParameters,
QMedAwardPayoutCalculator.Domain"/>
	</alias>

	<parameterMaps>
		<parameterMap id ="EmployeeParameters" class="EmployeeParticipants">
			<parameter property ="EmployeeID" column="employeeID"/>
			<parameter property="StartDate"  column="startDate"/>			
		</parameterMap>
	</parameterMaps>

	<statements>
		<select id="GetEmployeeCount"
			parameterMap="EmployeeParameters"
			resultClass="int">
			SELECT count(PT.EMPLID) as CourseCount
			FROM db1..tb1
			INNER JOIN db1..tb2 ON tb1.ID = tb2.ID
			WHERE tb1.FN = 'S'
			AND tb1.LN     = 'N'
			AND tb1.DATE > #startDate#         <--i think the issue exists here 
                        AND tb1.ID     = #employeeID#       <--DATE and ID
are in string	datatype		
		</select>
	</statements>
-- 
View this message in context: http://www.nabble.com/sql-in-sqlMap-tp23839118p23839118.html
Sent from the iBATIS - Dev mailing list archive at Nabble.com.