ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Diran Ayandele <Adediran.Ayand...@Sun.COM>
Subject Re: There is no WRITEABLE property called 'UserId' in AppUser
Date Thu, 06 Apr 2006 15:40:42 GMT
Maybe, since you've resolved the error with userid you should now change 
all your properties in the same manner.  Did I mention in my last note 
that capital first letters are generally used as uninstantiated object 
names?

Diran

Somasundaram Pitchaiah wrote:

>Hi meindert,
>I tried replacing UserId by userid in the XML file.but that didn't help.
>It still gives :
>There is no WRITEABLE property named 'DeviceId' in class
>'com.indidge.common.model.idtracksdevices.AppUser
>
>The error occurs while parsing auto generated
>XML(AppUser_SqlMap.xml).Following are the lines in that xml in the
>resultMap element:
>
><resultMap id="abatorgenerated_AppUserResult"
>class="com.indidge.common.model.idtracksdevices.AppUser">
>    <result column="UserId" property="UserId" jdbcType="BIGINT" />
>    <result column="FirstName" property="FirstName" jdbcType="VARCHAR" />
>
>a query in that XML;
>
><select id="abatorgenerated_selectByPrimaryKey"
>resultMap="abatorgenerated_AppUserResult"
>parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
>     select UserId, FirstName,
>     from idTracksDevices.AppUser
>    where UserId = #UserId#
>  </select>
>
>I need to parse this XML file so as to get the DAOManager Instance.
>I have attached SQlMap.XML,AppUser classes.
>
>Expecting ur help!
>
>Thank You!
>
>Regards,
>Somu
>
>
>
>
>____________________________________________________________________
>The property is called 'userId'
>
>MEINDERT
>
>-----Original Message-----
>From: Somasundaram Pitchaiah [mailto:[EMAIL PROTECTED]
>Sent: 06 April 2006 10:53 AM
>To: user-java@ibatis.apache.org
>Cc: [EMAIL PROTECTED]
>Subject: There is no WRITEABLE property called 'UserId' in AppUser
>
>Hi Every body,
>I'm facing problem while using the auto generated SQLmap files
>generated by abator in eclipse.
>
>I'm using abator plugin for eclipse(3.1) Given a table AppUser,abator
>generates the following  classes automatically:
>
>-AppUserDAO
>-AppUserImpl
>-AppUser_Sqlmap.xml
>
>I'm trying to use these classes to insert & select some values from Db
>for AppUser table.
>
>The error I get is that it gives"there is no WRITEABLE property called
>UserId in AppUser.This happens while trying to read AppUser_Sqlmap.xml.
>But I have the getter & setter method for the field 'Userid' in
>AppUser class(auto-generated).
>
> Files Attached:
>-Screenshot .doc(screenshot of the error)
>-AppUser_Sqlmap.xml
>-AppUser
>-SampleAction.java(action class)
>
>Expecting ur help!
>
>Thank you!
>
>Regards,
>Somu
>  
>
>------------------------------------------------------------------------
>
>package com.indidge.common.model.idtracksdevices;
>
>import java.util.Date;
>
>public class AppUser extends AppUserKey {
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.FirstName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String FirstName;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.MiddleInitial
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String MiddleInitial;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.LastName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String LastName;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.EmailAddr
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String EmailAddr;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Title
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String Title;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Department
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String Department;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Login
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String Login;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Passwd
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String Passwd;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Priv
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private Integer Priv;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.Active
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private Short Active;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.SystemAddUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String SystemAddUser;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.SystemAddDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private Date SystemAddDate;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.LastChangeUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private String LastChangeUser;
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.LastChangeDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private Date LastChangeDate;
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.FirstName
>     *
>     * @return the value of idTracksDevices.AppUser.FirstName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getFirstName() {
>        return FirstName;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.FirstName
>     *
>     * @param FirstName the value for idTracksDevices.AppUser.FirstName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setFirstName(String FirstName) {
>        if (FirstName != null) {
>            FirstName = FirstName.trim();
>        }
>        this.FirstName = FirstName;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.MiddleInitial
>     *
>     * @return the value of idTracksDevices.AppUser.MiddleInitial
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getMiddleInitial() {
>        return MiddleInitial;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.MiddleInitial
>     *
>     * @param MiddleInitial the value for idTracksDevices.AppUser.MiddleInitial
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setMiddleInitial(String MiddleInitial) {
>        if (MiddleInitial != null) {
>            MiddleInitial = MiddleInitial.trim();
>        }
>        this.MiddleInitial = MiddleInitial;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.LastName
>     *
>     * @return the value of idTracksDevices.AppUser.LastName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getLastName() {
>        return LastName;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.LastName
>     *
>     * @param LastName the value for idTracksDevices.AppUser.LastName
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setLastName(String LastName) {
>        if (LastName != null) {
>            LastName = LastName.trim();
>        }
>        this.LastName = LastName;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.EmailAddr
>     *
>     * @return the value of idTracksDevices.AppUser.EmailAddr
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getEmailAddr() {
>        return EmailAddr;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.EmailAddr
>     *
>     * @param EmailAddr the value for idTracksDevices.AppUser.EmailAddr
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setEmailAddr(String EmailAddr) {
>        if (EmailAddr != null) {
>            EmailAddr = EmailAddr.trim();
>        }
>        this.EmailAddr = EmailAddr;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Title
>     *
>     * @return the value of idTracksDevices.AppUser.Title
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getTitle() {
>        return Title;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Title
>     *
>     * @param Title the value for idTracksDevices.AppUser.Title
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setTitle(String Title) {
>        if (Title != null) {
>            Title = Title.trim();
>        }
>        this.Title = Title;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Department
>     *
>     * @return the value of idTracksDevices.AppUser.Department
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getDepartment() {
>        return Department;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Department
>     *
>     * @param Department the value for idTracksDevices.AppUser.Department
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setDepartment(String Department) {
>        if (Department != null) {
>            Department = Department.trim();
>        }
>        this.Department = Department;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Login
>     *
>     * @return the value of idTracksDevices.AppUser.Login
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getLogin() {
>        return Login;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Login
>     *
>     * @param Login the value for idTracksDevices.AppUser.Login
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setLogin(String Login) {
>        if (Login != null) {
>            Login = Login.trim();
>        }
>        this.Login = Login;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Passwd
>     *
>     * @return the value of idTracksDevices.AppUser.Passwd
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getPasswd() {
>        return Passwd;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Passwd
>     *
>     * @param Passwd the value for idTracksDevices.AppUser.Passwd
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setPasswd(String Passwd) {
>        if (Passwd != null) {
>            Passwd = Passwd.trim();
>        }
>        this.Passwd = Passwd;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Priv
>     *
>     * @return the value of idTracksDevices.AppUser.Priv
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public Integer getPriv() {
>        return Priv;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Priv
>     *
>     * @param Priv the value for idTracksDevices.AppUser.Priv
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setPriv(Integer Priv) {
>        this.Priv = Priv;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.Active
>     *
>     * @return the value of idTracksDevices.AppUser.Active
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public Short getActive() {
>        return Active;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.Active
>     *
>     * @param Active the value for idTracksDevices.AppUser.Active
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setActive(Short Active) {
>        this.Active = Active;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.SystemAddUser
>     *
>     * @return the value of idTracksDevices.AppUser.SystemAddUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getSystemAddUser() {
>        return SystemAddUser;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.SystemAddUser
>     *
>     * @param SystemAddUser the value for idTracksDevices.AppUser.SystemAddUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setSystemAddUser(String SystemAddUser) {
>        if (SystemAddUser != null) {
>            SystemAddUser = SystemAddUser.trim();
>        }
>        this.SystemAddUser = SystemAddUser;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.SystemAddDate
>     *
>     * @return the value of idTracksDevices.AppUser.SystemAddDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public Date getSystemAddDate() {
>        return SystemAddDate;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.SystemAddDate
>     *
>     * @param SystemAddDate the value for idTracksDevices.AppUser.SystemAddDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setSystemAddDate(Date SystemAddDate) {
>        this.SystemAddDate = SystemAddDate;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.LastChangeUser
>     *
>     * @return the value of idTracksDevices.AppUser.LastChangeUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public String getLastChangeUser() {
>        return LastChangeUser;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.LastChangeUser
>     *
>     * @param LastChangeUser the value for idTracksDevices.AppUser.LastChangeUser
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setLastChangeUser(String LastChangeUser) {
>        if (LastChangeUser != null) {
>            LastChangeUser = LastChangeUser.trim();
>        }
>        this.LastChangeUser = LastChangeUser;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.LastChangeDate
>     *
>     * @return the value of idTracksDevices.AppUser.LastChangeDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public Date getLastChangeDate() {
>        return LastChangeDate;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.LastChangeDate
>     *
>     * @param LastChangeDate the value for idTracksDevices.AppUser.LastChangeDate
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setLastChangeDate(Date LastChangeDate) {
>        this.LastChangeDate = LastChangeDate;
>    }
>}
>
>  
>
>------------------------------------------------------------------------
>
><?xml version="1.0" encoding="UTF-8"?>
><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
><sqlMap namespace="idTracksDevices_AppUser">
>
>  <resultMap id="abatorgenerated_AppUserResult" class="com.indidge.common.model.idtracksdevices.AppUser">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    <result column="UserId" property="UserId" jdbcType="BIGINT" />
>    <result column="FirstName" property="FirstName" jdbcType="VARCHAR" />
>    <result column="MiddleInitial" property="MiddleInitial" jdbcType="CHAR" />
>    <result column="LastName" property="LastName" jdbcType="VARCHAR" />
>    <result column="EmailAddr" property="EmailAddr" jdbcType="VARCHAR" />
>    <result column="Title" property="Title" jdbcType="VARCHAR" />
>    <result column="Department" property="Department" jdbcType="VARCHAR" />
>    <result column="Login" property="Login" jdbcType="VARCHAR" />
>    <result column="Passwd" property="Passwd" jdbcType="VARCHAR" />
>    <result column="Priv" property="Priv" jdbcType="INTEGER" />
>    <result column="Active" property="Active" jdbcType="SMALLINT" />
>    <result column="SystemAddUser" property="SystemAddUser" jdbcType="VARCHAR" />
>    <result column="SystemAddDate" property="SystemAddDate" jdbcType="TIMESTAMP" />
>    <result column="LastChangeUser" property="LastChangeUser" jdbcType="VARCHAR" />
>    <result column="LastChangeDate" property="LastChangeDate" jdbcType="TIMESTAMP" />
>  </resultMap>
>  <sql id="abatorgenerated_Example_Where_Clause">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    <dynamic prepend="where">
>      <isPropertyAvailable prepend="and" property="AND_UserId_NULL">
>        UserId is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_NULL">
>        UserId is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_NOT_NULL">
>        UserId is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_NOT_NULL">
>        UserId is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_EQUALS">
>        UserId = #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_EQUALS">
>        UserId = #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_NOT_EQUALS">
>        UserId <![CDATA[ <> ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_NOT_EQUALS">
>        UserId <![CDATA[ <> ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_GT">
>        UserId <![CDATA[ > ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_GT">
>        UserId <![CDATA[ > ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_GE">
>        UserId <![CDATA[ >= ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_GE">
>        UserId <![CDATA[ >= ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_LT">
>        UserId <![CDATA[ < ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_LT">
>        UserId <![CDATA[ < ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_UserId_LE">
>        UserId <![CDATA[ <= ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_UserId_LE">
>        UserId <![CDATA[ <= ]]> #UserId#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_NULL">
>        FirstName is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_NULL">
>        FirstName is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_NOT_NULL">
>        FirstName is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_NOT_NULL">
>        FirstName is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_EQUALS">
>        FirstName = #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_EQUALS">
>        FirstName = #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_NOT_EQUALS">
>        FirstName <![CDATA[ <> ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_NOT_EQUALS">
>        FirstName <![CDATA[ <> ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_GT">
>        FirstName <![CDATA[ > ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_GT">
>        FirstName <![CDATA[ > ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_GE">
>        FirstName <![CDATA[ >= ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_GE">
>        FirstName <![CDATA[ >= ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_LT">
>        FirstName <![CDATA[ < ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_LT">
>        FirstName <![CDATA[ < ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_LE">
>        FirstName <![CDATA[ <= ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_LE">
>        FirstName <![CDATA[ <= ]]> #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_FirstName_LIKE">
>        FirstName like #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_FirstName_LIKE">
>        FirstName like #FirstName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NULL">
>        MiddleInitial is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NULL">
>        MiddleInitial is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NOT_NULL">
>        MiddleInitial is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NOT_NULL">
>        MiddleInitial is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_EQUALS">
>        MiddleInitial = #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_EQUALS">
>        MiddleInitial = #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NOT_EQUALS">
>        MiddleInitial <![CDATA[ <> ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NOT_EQUALS">
>        MiddleInitial <![CDATA[ <> ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_GT">
>        MiddleInitial <![CDATA[ > ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_GT">
>        MiddleInitial <![CDATA[ > ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_GE">
>        MiddleInitial <![CDATA[ >= ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_GE">
>        MiddleInitial <![CDATA[ >= ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LT">
>        MiddleInitial <![CDATA[ < ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LT">
>        MiddleInitial <![CDATA[ < ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LE">
>        MiddleInitial <![CDATA[ <= ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LE">
>        MiddleInitial <![CDATA[ <= ]]> #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LIKE">
>        MiddleInitial like #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LIKE">
>        MiddleInitial like #MiddleInitial#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_NULL">
>        LastName is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_NULL">
>        LastName is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_NOT_NULL">
>        LastName is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_NOT_NULL">
>        LastName is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_EQUALS">
>        LastName = #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_EQUALS">
>        LastName = #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_NOT_EQUALS">
>        LastName <![CDATA[ <> ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_NOT_EQUALS">
>        LastName <![CDATA[ <> ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_GT">
>        LastName <![CDATA[ > ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_GT">
>        LastName <![CDATA[ > ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_GE">
>        LastName <![CDATA[ >= ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_GE">
>        LastName <![CDATA[ >= ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_LT">
>        LastName <![CDATA[ < ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_LT">
>        LastName <![CDATA[ < ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_LE">
>        LastName <![CDATA[ <= ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_LE">
>        LastName <![CDATA[ <= ]]> #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastName_LIKE">
>        LastName like #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastName_LIKE">
>        LastName like #LastName#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_NULL">
>        EmailAddr is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_NULL">
>        EmailAddr is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_NOT_NULL">
>        EmailAddr is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_NOT_NULL">
>        EmailAddr is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_EQUALS">
>        EmailAddr = #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_EQUALS">
>        EmailAddr = #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_NOT_EQUALS">
>        EmailAddr <![CDATA[ <> ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_NOT_EQUALS">
>        EmailAddr <![CDATA[ <> ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_GT">
>        EmailAddr <![CDATA[ > ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_GT">
>        EmailAddr <![CDATA[ > ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_GE">
>        EmailAddr <![CDATA[ >= ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_GE">
>        EmailAddr <![CDATA[ >= ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_LT">
>        EmailAddr <![CDATA[ < ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_LT">
>        EmailAddr <![CDATA[ < ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_LE">
>        EmailAddr <![CDATA[ <= ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_LE">
>        EmailAddr <![CDATA[ <= ]]> #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_EmailAddr_LIKE">
>        EmailAddr like #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_EmailAddr_LIKE">
>        EmailAddr like #EmailAddr#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_NULL">
>        Title is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_NULL">
>        Title is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_NOT_NULL">
>        Title is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_NOT_NULL">
>        Title is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_EQUALS">
>        Title = #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_EQUALS">
>        Title = #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_NOT_EQUALS">
>        Title <![CDATA[ <> ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_NOT_EQUALS">
>        Title <![CDATA[ <> ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_GT">
>        Title <![CDATA[ > ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_GT">
>        Title <![CDATA[ > ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_GE">
>        Title <![CDATA[ >= ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_GE">
>        Title <![CDATA[ >= ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_LT">
>        Title <![CDATA[ < ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_LT">
>        Title <![CDATA[ < ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_LE">
>        Title <![CDATA[ <= ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_LE">
>        Title <![CDATA[ <= ]]> #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Title_LIKE">
>        Title like #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Title_LIKE">
>        Title like #Title#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_NULL">
>        Department is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_NULL">
>        Department is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_NOT_NULL">
>        Department is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_NOT_NULL">
>        Department is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_EQUALS">
>        Department = #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_EQUALS">
>        Department = #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_NOT_EQUALS">
>        Department <![CDATA[ <> ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_NOT_EQUALS">
>        Department <![CDATA[ <> ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_GT">
>        Department <![CDATA[ > ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_GT">
>        Department <![CDATA[ > ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_GE">
>        Department <![CDATA[ >= ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_GE">
>        Department <![CDATA[ >= ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_LT">
>        Department <![CDATA[ < ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_LT">
>        Department <![CDATA[ < ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_LE">
>        Department <![CDATA[ <= ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_LE">
>        Department <![CDATA[ <= ]]> #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Department_LIKE">
>        Department like #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Department_LIKE">
>        Department like #Department#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_NULL">
>        Login is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_NULL">
>        Login is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_NOT_NULL">
>        Login is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_NOT_NULL">
>        Login is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_EQUALS">
>        Login = #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_EQUALS">
>        Login = #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_NOT_EQUALS">
>        Login <![CDATA[ <> ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_NOT_EQUALS">
>        Login <![CDATA[ <> ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_GT">
>        Login <![CDATA[ > ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_GT">
>        Login <![CDATA[ > ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_GE">
>        Login <![CDATA[ >= ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_GE">
>        Login <![CDATA[ >= ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_LT">
>        Login <![CDATA[ < ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_LT">
>        Login <![CDATA[ < ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_LE">
>        Login <![CDATA[ <= ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_LE">
>        Login <![CDATA[ <= ]]> #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Login_LIKE">
>        Login like #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Login_LIKE">
>        Login like #Login#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_NULL">
>        Passwd is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_NULL">
>        Passwd is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_NOT_NULL">
>        Passwd is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_NOT_NULL">
>        Passwd is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_EQUALS">
>        Passwd = #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_EQUALS">
>        Passwd = #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_NOT_EQUALS">
>        Passwd <![CDATA[ <> ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_NOT_EQUALS">
>        Passwd <![CDATA[ <> ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_GT">
>        Passwd <![CDATA[ > ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_GT">
>        Passwd <![CDATA[ > ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_GE">
>        Passwd <![CDATA[ >= ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_GE">
>        Passwd <![CDATA[ >= ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_LT">
>        Passwd <![CDATA[ < ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_LT">
>        Passwd <![CDATA[ < ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_LE">
>        Passwd <![CDATA[ <= ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_LE">
>        Passwd <![CDATA[ <= ]]> #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Passwd_LIKE">
>        Passwd like #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Passwd_LIKE">
>        Passwd like #Passwd#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_NULL">
>        Priv is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_NULL">
>        Priv is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_NOT_NULL">
>        Priv is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_NOT_NULL">
>        Priv is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_EQUALS">
>        Priv = #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_EQUALS">
>        Priv = #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_NOT_EQUALS">
>        Priv <![CDATA[ <> ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_NOT_EQUALS">
>        Priv <![CDATA[ <> ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_GT">
>        Priv <![CDATA[ > ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_GT">
>        Priv <![CDATA[ > ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_GE">
>        Priv <![CDATA[ >= ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_GE">
>        Priv <![CDATA[ >= ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_LT">
>        Priv <![CDATA[ < ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_LT">
>        Priv <![CDATA[ < ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Priv_LE">
>        Priv <![CDATA[ <= ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Priv_LE">
>        Priv <![CDATA[ <= ]]> #Priv#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_NULL">
>        Active is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_NULL">
>        Active is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_NOT_NULL">
>        Active is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_NOT_NULL">
>        Active is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_EQUALS">
>        Active = #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_EQUALS">
>        Active = #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_NOT_EQUALS">
>        Active <![CDATA[ <> ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_NOT_EQUALS">
>        Active <![CDATA[ <> ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_GT">
>        Active <![CDATA[ > ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_GT">
>        Active <![CDATA[ > ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_GE">
>        Active <![CDATA[ >= ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_GE">
>        Active <![CDATA[ >= ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_LT">
>        Active <![CDATA[ < ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_LT">
>        Active <![CDATA[ < ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_Active_LE">
>        Active <![CDATA[ <= ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_Active_LE">
>        Active <![CDATA[ <= ]]> #Active#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NULL">
>        SystemAddUser is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NULL">
>        SystemAddUser is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NOT_NULL">
>        SystemAddUser is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NOT_NULL">
>        SystemAddUser is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_EQUALS">
>        SystemAddUser = #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_EQUALS">
>        SystemAddUser = #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NOT_EQUALS">
>        SystemAddUser <![CDATA[ <> ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NOT_EQUALS">
>        SystemAddUser <![CDATA[ <> ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_GT">
>        SystemAddUser <![CDATA[ > ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_GT">
>        SystemAddUser <![CDATA[ > ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_GE">
>        SystemAddUser <![CDATA[ >= ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_GE">
>        SystemAddUser <![CDATA[ >= ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LT">
>        SystemAddUser <![CDATA[ < ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LT">
>        SystemAddUser <![CDATA[ < ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LE">
>        SystemAddUser <![CDATA[ <= ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LE">
>        SystemAddUser <![CDATA[ <= ]]> #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LIKE">
>        SystemAddUser like #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LIKE">
>        SystemAddUser like #SystemAddUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NULL">
>        SystemAddDate is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NULL">
>        SystemAddDate is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NOT_NULL">
>        SystemAddDate is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NOT_NULL">
>        SystemAddDate is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_EQUALS">
>        SystemAddDate = #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_EQUALS">
>        SystemAddDate = #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NOT_EQUALS">
>        SystemAddDate <![CDATA[ <> ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NOT_EQUALS">
>        SystemAddDate <![CDATA[ <> ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_GT">
>        SystemAddDate <![CDATA[ > ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_GT">
>        SystemAddDate <![CDATA[ > ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_GE">
>        SystemAddDate <![CDATA[ >= ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_GE">
>        SystemAddDate <![CDATA[ >= ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_LT">
>        SystemAddDate <![CDATA[ < ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_LT">
>        SystemAddDate <![CDATA[ < ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_SystemAddDate_LE">
>        SystemAddDate <![CDATA[ <= ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_SystemAddDate_LE">
>        SystemAddDate <![CDATA[ <= ]]> #SystemAddDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NULL">
>        LastChangeUser is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NULL">
>        LastChangeUser is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NOT_NULL">
>        LastChangeUser is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NOT_NULL">
>        LastChangeUser is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_EQUALS">
>        LastChangeUser = #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_EQUALS">
>        LastChangeUser = #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NOT_EQUALS">
>        LastChangeUser <![CDATA[ <> ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NOT_EQUALS">
>        LastChangeUser <![CDATA[ <> ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_GT">
>        LastChangeUser <![CDATA[ > ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_GT">
>        LastChangeUser <![CDATA[ > ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_GE">
>        LastChangeUser <![CDATA[ >= ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_GE">
>        LastChangeUser <![CDATA[ >= ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LT">
>        LastChangeUser <![CDATA[ < ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LT">
>        LastChangeUser <![CDATA[ < ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LE">
>        LastChangeUser <![CDATA[ <= ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LE">
>        LastChangeUser <![CDATA[ <= ]]> #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LIKE">
>        LastChangeUser like #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LIKE">
>        LastChangeUser like #LastChangeUser#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NULL">
>        LastChangeDate is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NULL">
>        LastChangeDate is null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NOT_NULL">
>        LastChangeDate is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NOT_NULL">
>        LastChangeDate is not null
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_EQUALS">
>        LastChangeDate = #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_EQUALS">
>        LastChangeDate = #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NOT_EQUALS">
>        LastChangeDate <![CDATA[ <> ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NOT_EQUALS">
>        LastChangeDate <![CDATA[ <> ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_GT">
>        LastChangeDate <![CDATA[ > ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_GT">
>        LastChangeDate <![CDATA[ > ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_GE">
>        LastChangeDate <![CDATA[ >= ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_GE">
>        LastChangeDate <![CDATA[ >= ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_LT">
>        LastChangeDate <![CDATA[ < ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_LT">
>        LastChangeDate <![CDATA[ < ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="and" property="AND_LastChangeDate_LE">
>        LastChangeDate <![CDATA[ <= ]]> #LastChangeDate#
>      </isPropertyAvailable>
>      <isPropertyAvailable prepend="or" property="OR_LastChangeDate_LE">
>        LastChangeDate <![CDATA[ <= ]]> #LastChangeDate#
>      </isPropertyAvailable>
>    </dynamic>
>  </sql>
>  <select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_AppUserResult" parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    select UserId,
>      FirstName,
>      MiddleInitial,
>      LastName,
>      EmailAddr,
>      Title,
>      Department,
>      Login,
>      Passwd,
>      Priv,
>      Active,
>      SystemAddUser,
>      SystemAddDate,
>      LastChangeUser,
>      LastChangeDate
>    from idTracksDevices.AppUser
>    where UserId = #UserId#
>  </select>
>  <select id="abatorgenerated_selectByExample" resultMap="abatorgenerated_AppUserResult" parameterClass="java.util.Map">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    select UserId,
>      FirstName,
>      MiddleInitial,
>      LastName,
>      EmailAddr,
>      Title,
>      Department,
>      Login,
>      Passwd,
>      Priv,
>      Active,
>      SystemAddUser,
>      SystemAddDate,
>      LastChangeUser,
>      LastChangeDate
>    from idTracksDevices.AppUser
>    <include refid="idTracksDevices_AppUser.abatorgenerated_Example_Where_Clause"/>
>    <isPropertyAvailable property="ABATOR_ORDER_BY_CLAUSE">
>      order by $ABATOR_ORDER_BY_CLAUSE$
>    </isPropertyAvailable>
>  </select>
>  <delete id="abatorgenerated_deleteByPrimaryKey" parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    delete from idTracksDevices.AppUser
>    where UserId = #UserId#
>  </delete>
>  <delete id="abatorgenerated_deleteByExample" parameterClass="java.util.Map">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    delete from idTracksDevices.AppUser
>    <include refid="idTracksDevices_AppUser.abatorgenerated_Example_Where_Clause"/>
>  </delete>
>  <insert id="abatorgenerated_insert" parameterClass="com.indidge.common.model.idtracksdevices.AppUser">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    insert into idTracksDevices.AppUser (UserId, FirstName, MiddleInitial, 
>      LastName, EmailAddr, Title, Department, Login, Passwd, Priv, Active, 
>      SystemAddUser, SystemAddDate, LastChangeUser, LastChangeDate) 
>    values (#UserId:BIGINT#, #FirstName:VARCHAR#, #MiddleInitial:CHAR#, 
>      #LastName:VARCHAR#, #EmailAddr:VARCHAR#, #Title:VARCHAR#, 
>      #Department:VARCHAR#, #Login:VARCHAR#, #Passwd:VARCHAR#, #Priv:INTEGER#, 
>      #Active:SMALLINT#, #SystemAddUser:VARCHAR#, #SystemAddDate:TIMESTAMP#, 
>      #LastChangeUser:VARCHAR#, #LastChangeDate:TIMESTAMP#) 
>  </insert>
>  <update id="abatorgenerated_updateByPrimaryKey" parameterClass="com.indidge.common.model.idtracksdevices.AppUser">
>    <!--
>      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
>      This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
>    -->
>    update idTracksDevices.AppUser
>    set FirstName = #FirstName:VARCHAR#,
>      MiddleInitial = #MiddleInitial:CHAR#,
>      LastName = #LastName:VARCHAR#,
>      EmailAddr = #EmailAddr:VARCHAR#,
>      Title = #Title:VARCHAR#,
>      Department = #Department:VARCHAR#,
>      Login = #Login:VARCHAR#,
>      Passwd = #Passwd:VARCHAR#,
>      Priv = #Priv:INTEGER#,
>      Active = #Active:SMALLINT#,
>      SystemAddUser = #SystemAddUser:VARCHAR#,
>      SystemAddDate = #SystemAddDate:TIMESTAMP#,
>      LastChangeUser = #LastChangeUser:VARCHAR#,
>      LastChangeDate = #LastChangeDate:TIMESTAMP#
>    where UserId = #UserId#
>  </update>
></sqlMap>
>
>  
>
>------------------------------------------------------------------------
>
>package com.indidge.common.model.idtracksdevices;
>
>
>public class AppUserKey {
>
>    /**
>     * This field was generated by Abator for iBATIS.
>     * This field corresponds to the database column idTracksDevices.AppUser.UserId
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    private Long UserId;
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method returns the value of the database column idTracksDevices.AppUser.UserId
>     *
>     * @return the value of idTracksDevices.AppUser.UserId
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public Long getUserId() {
>        return UserId;
>    }
>
>    /**
>     * This method was generated by Abator for iBATIS.
>     * This method sets the value of the database column idTracksDevices.AppUser.UserId
>     *
>     * @param UserId the value for idTracksDevices.AppUser.UserId
>     *
>     * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
>     */
>    public void setUserId(Long UserId) {
>        this.UserId = UserId;
>    }
>}
>  
>

Mime
View raw message