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# ]]>

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

@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

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message