Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 96189 invoked from network); 19 May 2005 21:02:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 19 May 2005 21:02:28 -0000 Received: (qmail 8066 invoked by uid 500); 19 May 2005 20:13:42 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 7976 invoked by uid 500); 19 May 2005 20:13:40 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 7901 invoked by uid 99); 19 May 2005 20:13:39 -0000 X-ASF-Spam-Status: No, hits=0.3 required=10.0 tests=FORGED_RCVD_HELO,HTML_MESSAGE,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.poindextersystems.com (HELO svmx.pdex.com) (165.254.178.100) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 19 May 2005 13:13:18 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C55CAF.158144AF" Subject: RE: [HELP] I can't not type < sign in my sqlmap xml file Date: Thu, 19 May 2005 16:12:29 -0400 Message-ID: <0F3B5810532DAE4F843EC9E4DEFD9F63BCD96B@svmx.pdex.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [HELP] I can't not type < sign in my sqlmap xml file Thread-Index: AcVcrfhhMSYS30wdS1KNDHO8s6OfnQAAHymw From: "Elizabeth Baron" To: X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C55CAF.158144AF Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Anh, =20 If I understand what you are saying, you need to use the "<" character in your iBatis map. This is possible by using the CDATA tags. I have included an example below. The only problem I see with CDATA is that you might not be able to use dynamic sql in the future. =20 Does anyone know? =20 Thanks, Liz =20 =20 ________________________________ From: Pham Anh Tuan [mailto:anhtuan@ichi-corp.jp]=20 Sent: Thursday, May 19, 2005 5:06 AM To: ibatis-user-java@incubator.apache.org Subject: [HELP] I can't not type < sign in my sqlmap xml file =20 Hi, =20 I can't not type < sign in sql definition xml file, I don't know why, plz help me solve this problem :( =20 report error: The content of elements must consist of well-formed character data or markup Thanks for reading Anh Tuan ------_=_NextPart_001_01C55CAF.158144AF Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi = Anh,

If I understand what you are = saying, you need to use the “<” character in your iBatis map. = This is possible by using the CDATA tags. I have included an example = below. The only problem I see with CDATA is that you might not be able to use dynamic = sql in the future.

Does anyone = know?

Thanks,

=

Liz

<select id=3D"getNOFBidding" resultClass=3D"int" = parameterClass=3D"string">

<![CDATA[

select COUNT(distinct ITEMID)

from SALE =

where SALESTATUS =3D 0 and MAXPRICE =3D 1

and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) <=3D 15 and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) > 0 =

and BUYERUSERID =3D #value#

]]>

</select>

From: Pham = Anh Tuan [mailto:anhtuan@ichi-corp.jp]
Sent: Thursday, May 19, = 2005 5:06 AM
To: ibatis-user-java@incubator.apache.org
Subject: [HELP] I can't = not type < sign in my sqlmap xml file

Hi,

I can't not type < sign in sql definition xml = file, I don't know why, plz help me solve this problem = :(

<select id=3D"getNOFBidding" resultClass=3D"int" = parameterClass=3D"string">

select COUNT(distinct ITEMID)

from SALE =

where SALESTATUS =3D 0 and MAXPRICE =3D 1

and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) <=3D 15 and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) > 0 =

and BUYERUSERID =3D #value#

</select>

report error: The content of elements must consist of = well-formed character data or markup

Thanks for = reading

Anh Tuan

------_=_NextPart_001_01C55CAF.158144AF--