I map bools to bits in SQL server all the time without issue. Can you post the 
complete mapping statement?


________________________________
> Date: Wed, 3 Jun 2009 16:13:49 +0200
> Subject: Exception on Update
> From: marco.frans...@gmail.com
> To: user-cs@ibatis.apache.org
>
> Hello,
>
> I get the following exception when executing an update statement.
>
> Wrong value near '='
>
> I found out that it has to do with the bool value of mij object that wont be 
> converted to the bit value in mij sqlserver database.
>
>
> In my update I tried the following:
>
> SET active = #Active#
>
> I also tried the following
>
> SET active = #Active:Bit#
>
>
> Both won't work I run Ibatis version 1.6.1
>
> When I remove this line and I just do not set the active field the query 
> works, so thats why I am realy sure it has to do with this line. Is there 
> someone who knows how to tackle this problem.
>
> --
> Kindly regards,
>
> Marco Franssen
>
_________________________________________________________________
Lauren found her dream laptop. Find the PC that’s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290

Reply via email to