Example 26 from DevGuide.pdf explains the nullValue attribute: <resultMap id=”get-product-result” class=”product”> <result property=”id” column=”PRD_ID”/> <result property=”description” column=”PRD_DESCRIPTION”/> <result property=”subCode” column=”PRD_SUB_CODE” nullValue=”-9999”/> </resultMap>
Is it possible to set nullValue to string.Empty? I've tried "" but nullValue seems to be ignored unless its length is greater than zero. This may be unrelated, but I noticed this line in one of the other XML files: <parameter property="Date" nullValue="01/01/0001 00:00:00" /> I thought that I could someone solve the constant problem by defining the .Net 1.1 constants in a properties files somewhere: <!-- simulate .Net 1.1 constants --> <add key="DateTime.MinValue" value="01/01/0001 00:00:00" /> Then in the other file do: <parameter property="Date" nullValue="${DateTime.MinValue}" /> That still doesn't explain how to express string.Empty... Thanks, Ron