Author: rgrabowski
Date: Sat Nov 19 12:29:48 2005
New Revision: 345683
URL: http://svn.apache.org/viewcvs?rev=345683&view=rev
Log:
Improved SelectOrderByDateDynamic statement for IBATISNET-29 when tested
against Access. Access requires pound signs instead of single quotes for
literal dates.
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Order.xml
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Order.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Order.xml?rev=345683&r1=345682&r2=345683&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Order.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Order.xml
Sat Nov 19 12:29:48 2005
@@ -370,11 +370,12 @@
select * from Orders where Order_Date = #Foo#
</select>
+ <!-- Access requires pound signs instead of single quotes for
literal dates -->
<select id="SelectOrderByDateDynamic"
parameterClass="Hashtable" resultMap="lite-order-result-by-name">
select * from Orders
where 1=1
<isNotEmpty prepend="AND" property="Foo">
- (Order_Date = '$Foo$')
+ (Order_Date = ##$Foo$##)
</isNotEmpty>
</select>
