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.

Reply via email to