Hello!
I have a case expression in my SQL query similar to
the following:
sum(case when code = 'tck$' then amount else 0 end) as
ticketSales
When the case expression is written like that, I
receive a
com.ibatis.common.jdbc.exception.NestedSQLException.
I changed the case expression to the following and it
works just fine:
sum(case when code like 'tck%' then amount else 0 end)
as ticketSales
Is there a way to escape the $ in my SQL query so that
it won't cause a
com.ibatis.common.jdbc.exception.NestedSQLException?
Or in general how do you escape characters in your SQL
query that have special meaning in iBatis (like the
#)?
Thanks,
Mark
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
