Good to see this finally got fixed. Was the problem in how the sql was parsed or how the IDbParameter was being populated?
--- "Gilles Bayon (JIRA)" <ibatis-dev@incubator.apache.org> wrote: > [ http://issues.apache.org/jira/browse/IBATISNET-30?page=all ] > > Gilles Bayon closed IBATISNET-30: > --------------------------------- > > Resolution: Fixed > Fix Version: DataMapper 1.2 > > Fix in SVN > > > bug in ApplyParameterMap > > ------------------------ > > > > Key: IBATISNET-30 > > URL: http://issues.apache.org/jira/browse/IBATISNET-30 > > Project: iBatis for .NET > > Type: Bug > > Versions: DataMapper 1.2 > > Reporter: Jakob Rojel > > Assignee: Gilles Bayon > > Fix For: DataMapper 1.2 > > > > > If my XML file contains > > <isNotNull prepend="and" property="NumberSearch"> > > ((inline.order_number $Number_Oper$ #NumberSearch#) or > (inline.invoice_number $Number_Oper$ #NumberSearch#)) > > </isNotNull> > > <isEqual prepend = "and" property="InvoiceStatusAnd" > compareValue="true"> > > (inline.invoice_state = #InvoiceStatus#) > > </isEqual> > > <isEqual prepend = "and" property="OrderStatusAnd" > compareValue="true"> > > (inline.order_state = #OrderStatus#) > > </isEqual> > > My parameter for NumberSearch is copied into InvoiceStatus, the > following works. > > <isEqual prepend = "and" property="InvoiceStatusAnd" > compareValue="true"> > > (inline.invoice_state = #InvoiceStatus#) > > </isEqual> > > <isEqual prepend = "and" property="OrderStatusAnd" > compareValue="true"> > > (inline.order_state = #OrderStatus#) > > </isEqual> > > <isNotNull prepend="and" property="NumberSearch"> > > ((inline.order_number $Number_Oper$ #NumberSearch#) or > (inline.invoice_number $Number_Oper$ #NumberSearch#)) > > </isNotNull> > > My pretty sure that that the problem is related to the fact that > NumberSearch is used twice > > When I debug the following code in ApplyParameterMap > > if ( propertyName != "value" ) // Inline Parameters && > > Parameters > via ParameterMap > > { > > ParameterProperty property = > request.ParameterMap.GetProperty(i); > > sqlParameter.Value = > request.ParameterMap.GetValueOfProperty(parameterObject, > > > > property.PropertyName); > > } > > propertyName is InvoiceStatus and property.PropertyName is > NumberSearch > > > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of the > administrators: > http://issues.apache.org/jira/secure/Administrators.jspa > - > For more information on JIRA, see: > http://www.atlassian.com/software/jira > >
