I have a sql statement in my SqlMaps like this:
<select id="GetEmployeeCount"
parameterMap="EmployeeParameters"
resultClass="int">
SELECT count(EMP.EMPLID) as EmployeeCount
FROM EmployeeHome EMP
WHERE EMP.ATTENDANCE = 'C'
AND EMP.END_DT >= #startDate#,
AND EMP.END_DT < #endDate# <--error appears in this
linke, just
below the '<' sign
AND EMP.EMPLID = #employeeID#
</select>
error message: "Illegal Syntax. Expecting valid start name character."
Does anyone know why i am getting this error?
--
View this message in context:
http://www.nabble.com/sqlMaps-error--tp23338997p23338997.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.