You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Jakob Rojel (JIRA)" <ib...@incubator.apache.org> on 2004/12/01 11:59:20 UTC

[jira] Created: (IBATISNET-11) Incorrect binding of properties of dynamic select

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

[jira] Closed: (IBATISNET-11) Incorrect binding of properties of dynamic select

Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
     [ http://nagoya.apache.org/jira/browse/IBATISNET-11?page=history ]
     
Gilles Bayon closed IBATISNET-11:
---------------------------------

     Assign To: Gilles Bayon
    Resolution: Cannot Reproduce

I have do a unit test 'TestJIRA11' to mimic your configuration but I was unable to reproduce your issue with the current source in SVN so I closed it.
It will be in the next release 1.1 (it's already in SVN (365) if you want to try it).  

> 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
>     Assignee: Gilles Bayon

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