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.
