In SQL server, if you have an expression where currentDate=null
you don't get the correct response. If you put where currentDate is null you get the correct response.
The framework is currently producing the first as part of its query, not the second.
How can I get the framework to product the second type of condition for NULL's
Thanks Saul
Add the following to your database mapping in the .XML file.
<parameter name="ansinulls" value="true"/>
And it will work correctly.
Log in to post a comment.
In SQL server, if you have an expression
where currentDate=null
you don't get the correct response. If you put
where currentDate is null
you get the correct response.
The framework is currently producing the first as part of its query, not the second.
How can I get the framework to product the second type of condition for NULL's
Thanks
Saul
Add the following to your database mapping in the .XML file.
<parameter name="ansinulls" value="true"/>
And it will work correctly.