EMP.*START*_DT >= #startDate#, AND EMP.END_DT < #endDate# Try the thing I made bold.
2009/5/1 sanjeev40084 <[email protected]> > > 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. > > -- Met vriendelijke groet, Marco Franssen
