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