ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jakob Rojel (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Created: (IBATISNET-11) Incorrect binding of properties of dynamic select
Date Wed, 01 Dec 2004 10:59:20 GMT
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


Mime
View raw message