Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <4399C793.6020908@cnet.com>
Date: Fri, 09 Dec 2005 10:06:11 -0800
From: Reuben Firmin <reuben.firmin@cnet.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: How to define not equal (<>) in SQL statement
References: <20051209180127.12341.qmail@web32810.mail.mud.yahoo.com>
In-Reply-To: <20051209180127.12341.qmail@web32810.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Use the CDATA construct, e.g.:

        <![CDATA[
            SELECT * FROM Deployment
            WHERE environmentId = #environmentId#
            AND deploymentTime <= #end#
            AND deploymentTime >= #start#
            ORDER BY deploymentTime DESC
        ]]>

Ashish Kulkarni wrote:

>Hi
>I have a SQL statement as below, how do i define it in
>xml 
>
>select * from mytable where mytest <> ' '
>
>When i define it in xml file i get following error
>
>The content beginning "<>" is not legal markup.
>Perhaps the ">" (e;) character should be a letter.
>
>
>Ashish
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>  
>