ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TNO <tno...@free.fr>
Subject Re: Postgres - inserting null causes error - Unknown Types value
Date Wed, 14 Sep 2005 08:23:24 GMT
In my DAOiBatis, I check if idDivers is not null before update.

May be it is not usefull to write
WHERE     i_divers = #idDivers:Long#
but simply
WHERE     i_divers = #idDivers#

Darek Dober a écrit :

> From my perspective, it should be ok.
>  
> But:
> WHERE     i_divers = #idDivers:Long#
>  
> you shouldn't update something, if you don't know which record you 
> want to update (if idDivers is null :)
>
>  
>  
> Have you tried this ?
>  
> Cheers
> Darek
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.344 / Virus Database: 267.10.24/101 - Release Date: 13/09/2005
>
>  
>


-- 
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...


Mime
View raw message