Return-Path: 
 <user-java-return-4246-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 76681 invoked from network); 19 Sep 2005 03:22:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Sep 2005 03:22:15 -0000
Received: (qmail 76502 invoked by uid 500); 19 Sep 2005 03:22:14 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 76484 invoked by uid 500); 19 Sep 2005 03:22:13 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 76470 invoked by uid 99); 19 Sep 2005 03:22:13 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Sep 2005 20:22:13 -0700
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=HTML_30_40,HTML_MESSAGE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com
 designates 72.14.204.206 as permitted sender)
Received: from [72.14.204.206] (HELO qproxy.gmail.com) (72.14.204.206)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Sep 2005 20:22:22 -0700
Received: by qproxy.gmail.com with SMTP id o38so166939qbe
        for <user-java@ibatis.apache.org>;
 Sun, 18 Sep 2005 20:22:09 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references;
        b=Yoywq7YpgS8CRkLfVfbq+lSsDW368/5aGoy5bhNLR8uyR/XVKhzEhFsFwcuuMOdx3x24MJhnIbFWTWcdEM/bvpYotP+OwAdyCETOv7RU4xrfqd12ausrAfJzrk7UJW+kmtnhbgjL4xRIgcxE2gNIWy9sgG4+OutUReuXO+BkiL4=
Received: by 10.64.249.12 with SMTP id w12mr33977qbh;
        Sun, 18 Sep 2005 20:22:09 -0700 (PDT)
Received: by 10.64.10.17 with HTTP; Sun, 18 Sep 2005 20:22:09 -0700 (PDT)
Message-ID: <16178eb10509182022108e7d23@mail.gmail.com>
Date: Sun, 18 Sep 2005 21:22:09 -0600
From: Clinton Begin <clinton.begin@gmail.com>
Reply-To: clinton.begin@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Escaping the PLUS character in selects
In-Reply-To: <1132.222.253.65.82.1127099936.squirrel@webmail.uio.no>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_28681_31223022.1127100129702"
References: <1132.222.253.65.82.1127099936.squirrel@webmail.uio.no>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_28681_31223022.1127100129702
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Plus isn't reserved by iBATIS...

So I'm not sure what could be going on. Try putting a space between=20
So_PN_duoc_tiem_UV2 +=20

Clinton

On 9/18/05, chriskle@student.matnat.uio.no <chriskle@student.matnat.uio.no>=
=20
wrote:
>=20
> hey,
> Im having a problem when trying to select a field with a PLUS character.
> My select goes like this:
> SELECT
> So_PN_duoc_tiem_UV2+ AS de7
> FROM ...
>=20
> the error i get is "missing operator in the select statement."
>=20
> ive tried escaping it by adding both one, two and three extra plus
> characters, with no luck, altho this seems to work for other special
> characters. The question is therefor, how do i escaping the PLUS
> character?
>=20
>=20
>=20
>=20
>

------=_Part_28681_31223022.1127100129702
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br>
Plus isn't reserved by iBATIS...<br>
<br>
So I'm not sure what could be going on.&nbsp; Try putting a space between  =
So_PN_duoc_tiem_UV2 + <br><br>
Clinton<br>
<br><div><span class=3D"gmail_quote">On 9/18/05, <b class=3D"gmail_senderna=
me"><a href=3D"mailto:chriskle@student.matnat.uio.no">chriskle@student.matn=
at.uio.no</a></b> &lt;<a href=3D"mailto:chriskle@student.matnat.uio.no">chr=
iskle@student.matnat.uio.no
</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D"border-lef=
t: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1=
ex;">hey,<br>Im having a problem when trying to select a field with a PLUS =
character.
<br>My select goes like this:<br>SELECT<br> So_PN_duoc_tiem_UV2+ AS de7<br>=
FROM ...<br><br>the error i get is &quot;missing operator in the select sta=
tement.&quot;<br><br>ive tried escaping it by adding both one, two and thre=
e extra plus
<br>characters, with no luck, altho this seems to work for other special<br=
>characters. The question is therefor, how do i escaping the PLUS<br>charac=
ter?<br><br><br><br><br></blockquote></div><br>

------=_Part_28681_31223022.1127100129702--