Incorrect binding of properties of dynamic select
-------------------------------------------------
Key: IBATISNET-11
URL: http://nagoya.apache.org/jira/browse/IBATISNET-11
Project: iBatis for .NET
Type: Bug
Environment: XP, SQL Server
Reporter: Jakob Rojel
I have a dynamic where clause like this
<dynamic prepend="where">
<isNotNull prepend="and" property="NumberSearch">
((inline.order_number $Number_Oper$ #NumberSearch#) or
(inline.invoice_number $Number_Oper$ #NumberSearch#)) </isNotNull>
<isEqual prepend="and" property="StartDateAnd" compareValue="true">
<![CDATA[inline.invoice_date >= #StartDate# ]]>
</isEqual>
</dynamic>
It works fine if I only supply StartDate (StartDataAnd is a workaround for
isNotEqual malfunction)
But when I supply %123% in NumberSearch and like in Number_Oper the values are
bound like this
@NumberSearch = N'%123%', @StartDate = N'%123%'
This is quite urgent for my project so I'll like to help in any possible way
phone/email discussions etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
