Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of zoran@sparecreative.com
 designates 150.101.158.37 as permitted sender)
User-Agent: Microsoft-Entourage/11.4.0.080122
Date: Tue, 14 Apr 2009 12:51:38 +1000
Subject: Re: 
From: Zoran Avtarovski <zoran@sparecreative.com>
To: iBatis Java Mail List <user-java@ibatis.apache.org>
Message-ID: <C60A375A.A3760%zoran@sparecreative.com>
Thread-Index: Acm8q+5JLRzVSCifEd6EBAANkyympA==
In-Reply-To: <a10a823c0904131859n55242d69j1f4d97d74f49fe81@mail.gmail.com>
Mime-version: 1.0
Content-type: multipart/alternative;
	boundary="B_3322558299_26846776"

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3322558299_26846776
Content-type: text/plain;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

That=B9s why I=B9ve never managed to get it to work. Can I suggest that for the
next version the logic be reversed on inserts. It=B9s not a big deal as it
makes sense to implement this type of logic in the business layer but for
simple projects it might be beneficial.

Z.

>=20
> Null value replacement makes my head hurt.
>=20
> It bit me, because it worked exactly the OPPOSITE of what I expected.
>=20
> When doing a select, if the database value is null, ibatis will use
> the replacement value for your result.
>=20
> When doing an insert, if the parameter property is the replacement
> value, it'll put null in the database.
>=20
> So in this case, it's doing nothing.
>=20
> :-/
>=20
> However, IIRC, if you set thing.animal to false, it'll use null in the
> database instead.
>=20
> Larry
>=20
>=20
> PS: Hey, aren't you the captain of "The Love Boat"? Oh, no that was
> Gavin MacLeod...nevermind. :-P


--B_3322558299_26846776
Content-type: text/html;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: </TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Courier, Courier New"><SPAN STYLE=3D'font-size:12.0px'>That&#8217=
;s why I&#8217;ve never managed to get it to work. Can I suggest that for th=
e next version the logic be reversed on inserts. It&#8217;s not a big deal a=
s it makes sense to implement this type of logic in the business layer but f=
or simple projects it might be beneficial.<BR>
<BR>
Z.<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Courier, Courier New"><SPAN STYLE=3D'fo=
nt-size:12.0px'><BR>
Null value replacement makes my head hurt.<BR>
<BR>
It bit me, because it worked exactly the OPPOSITE of what I expected.<BR>
<BR>
When doing a select, if the database value is null, ibatis will use<BR>
the replacement value for your result.<BR>
<BR>
When doing an insert, if the parameter property is the replacement<BR>
value, it'll put null in the database.<BR>
<BR>
So in this case, it's doing nothing.<BR>
<BR>
:-/<BR>
<BR>
However, IIRC, if you set thing.animal to false, it'll use null in the<BR>
database instead.<BR>
<BR>
Larry<BR>
<BR>
<BR>
PS: Hey, aren't you the captain of &quot;The Love Boat&quot;? Oh, no that w=
as<BR>
Gavin MacLeod...nevermind. :-P<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Courier, Courier New"><SPAN STYLE=3D'f=
ont-size:12.0px'><BR>
</SPAN></FONT>
</BODY>
</HTML>


--B_3322558299_26846776--