Re: A bug found for IBatis.Net. Can not handle boolean type for MS Access

[Roberto R <ro...@gmail.com>]

You'll have to coax the DataMapper to handle the Access Yes/No field by 
specifying "Boolean" either inline or in a parameterMap.

Roberto

On 9/12/05, Ling Wang <li...@yahoo.com> wrote:
> 
> I downloaded the tutorial and added a boolean
> (yes/no)field (PER_IS_MALE) to the person table. I
> also added a bool field to the person class and added
> all the mappings in the personhelper.xml file. When I
> run the application, I am getting the failures:
> 
> System.Data.OleDb.OleDbException: Syntax error
> (missing operator) in query expression '? PER_IS_MALE
> = ?'.
> 
> Can someone take a look and confirm it? It should only
> take less than 10 minutes.
> 
> Thanks.
> 
> Ling
>

Re: A bug found for IBatis.Net. Can not handle boolean type for MS Access

[Ron Grabowski <ro...@yahoo.com>]

That was the case a release or two ago (for SQL Server at least) but I
thought the current binary download didn't require the :Boolean syntax.


This is a snippet from one of my mapping files. Published is a bool and
is mapped to a Yes/No column.

 <isPropertyAvailable property="Published">
  AND (Product.Published = #Published#)
 </isPropertyAvailable>

--- Roberto R <ro...@gmail.com> wrote:

> You'll have to coax the DataMapper to handle the Access Yes/No field
> by 
> specifying "Boolean" either inline or in a parameterMap.
> 
> Roberto
> 
> On 9/12/05, Ling Wang <li...@yahoo.com> wrote:
> > 
> > I downloaded the tutorial and added a boolean
> > (yes/no)field (PER_IS_MALE) to the person table. I
> > also added a bool field to the person class and added
> > all the mappings in the personhelper.xml file. When I
> > run the application, I am getting the failures:
> > 
> > System.Data.OleDb.OleDbException: Syntax error
> > (missing operator) in query expression '? PER_IS_MALE
> > = ?'.
> > 
> > Can someone take a look and confirm it? It should only
> > take less than 10 minutes.
> > 
> > Thanks.
> > 
> > Ling
> >
>