thanks..yupe that's what i did. works fine now.
--
View this message in context:
http://www.nabble.com/sql-in-sqlMap-tp23839118p23839433.html
Sent from the iBATIS - Dev mailing list archive at Nabble.com.
OM 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 h
# <--i think the issue
exists here
AND tb1.ID = #employeeID# <--DATE and ID
are in string datatype
--
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.
