ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Escaping the PLUS character in selects
Date Mon, 19 Sep 2005 05:08:47 GMT
Holy crap. the + was part of the column name? I thought you were doing 
arithmetic in the SELECT (which isn't too bad). But man!!!! What exactly 
does the plus signify? Is it just that much better than 
"So_PN_duoc_tiem_UV2" a horrible column name to begin with. Must be a 
mainframe conversion. 

Clinton

On 9/18/05, chriskle@student.matnat.uio.no <chriskle@student.matnat.uio.no> 
wrote:
> 
> hehe, that worked so need for any wringing.. :)
> thanks!
> 
> > Did you try "So_PN_duoc_tiem_UV2+"?
> >
> > If that doesn't work, hunt down the guy who used a + in a column name,
> > and wring his...errr, nevermind. ;-)
> >
> > Larry
> >
> >
> > On 9/18/05, chriskle@student.matnat.uio.no
> > <chriskle@student.matnat.uio.no> wrote:
> >> 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 ...
> >>
> >> the error i get is "missing operator in the select statement."
> >>
> >> 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?
> >>
> >>
> >>
> >>
> >>
> >
> 
> 
>

Mime
View raw message