You're missing a comma: PER_HEIGHT_M = #HeightInMeters#, PER_IS_MALE = #IsMale#
--- Ling Wang <[EMAIL PROTECTED]> wrote: > Ron, > > Here is the mapping file: > > <?xml version="1.0" encoding="utf-8" ?> > > <sqlMap > namespace="Person" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > xsi:noNamespaceSchemaLocation="SqlMap.xsd"> > > <!-- XML "behind" document for the People service > class. --> > > <alias> > <typeAlias alias="Person" > type="iBatisTutorial.Model.Person, > iBatisTutorial.Model" /> > </alias> > > <resultMaps> > <resultMap id="SelectResult" class="Person"> > <result property="Id" column="PER_ID" /> > <result property="FirstName" > column="PER_FIRST_NAME" /> > <result property="LastName" column="PER_LAST_NAME" > /> > <result property="BirthDate" > column="PER_BIRTH_DATE" /> > <result property="WeightInKilograms" > column="PER_WEIGHT_KG" /> > <result property="HeightInMeters" > column="PER_HEIGHT_M" /> > <result property="IsMale" column="PER_IS_MALE" /> > </resultMap> > </resultMaps> > > <statements> > > <select id="Select" parameterClass="int" > resultMap="SelectResult"> > select > PER_ID, > PER_FIRST_NAME, > PER_LAST_NAME, > PER_BIRTH_DATE, > PER_WEIGHT_KG, > PER_HEIGHT_M, > PER_IS_MALE > from PERSON > <dynamic prepend="WHERE"> > <isParameterPresent> > PER_ID = #value# > </isParameterPresent> > </dynamic> > </select> > > <insert id="Insert" parameterClass="Person"> > insert into PERSON > (PER_ID, PER_FIRST_NAME, PER_LAST_NAME, > PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M, > PER_IS_MALE) > values > (#Id#, #FirstName#, #LastName#, > #BirthDate#, #WeightInKilograms#, > #HeightInMeters#, #IsMale#) > </insert> > > <update id="Update" parameterClass="Person"> > update PERSON set > PER_FIRST_NAME = #FirstName#, > PER_LAST_NAME = #LastName#, > PER_BIRTH_DATE = #BirthDate#, > PER_WEIGHT_KG = #WeightInKilograms#, > PER_HEIGHT_M = #HeightInMeters# > PER_IS_MALE = #IsMale# > where PER_ID = #Id# > </update> > > <delete id="Delete" parameterClass="int"> > delete from PERSON > where PER_ID = #value# > </delete> > > </statements> > > </sqlMap> > > and the Person class: > > namespace iBatisTutorial.Model > { > > > public class Person > { > > > > private bool _IsMale = true; > public bool IsMale > { > get { return _IsMale; } > set { _IsMale = value; } > } > > private int _Id; > public int Id > { > get { return _Id; } > set { _Id = value; } > } > > private string _FirstName; > public string FirstName > { > get { return _FirstName; } > set { _FirstName = value; } > } > > private string _LastName; > public string LastName > { > get { return _LastName; } > set { _LastName = value; } > } > > private DateTime _BirthDate = DateTime.Now; > public DateTime BirthDate > { > get { return _BirthDate; } > set { _BirthDate = value; } > } > > private double _WeightInKilograms; > public double WeightInKilograms > { > get { return _WeightInKilograms; } > set { _WeightInKilograms = value; } > } > > private double _HeightInMeters; > public double HeightInMeters > { > get { return _HeightInMeters; } > set { _HeightInMeters = value; } > } > > } > } > > --- Ron Grabowski <[EMAIL PROTECTED]> wrote: > > > I use IBatisNet, Access, and Yes/No columns everyday > > without issue. > > > > Can you post your xml mapping file please. > > > > Thanks, > > Ron > > > > --- Ling Wang <[EMAIL PROTECTED]> 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 > > > > > > > > >
