You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Henry Lu <zh...@umich.edu> on 2005/08/11 19:29:01 UTC

sql include #

How do I use a SQL statemen including a column name with #:

EXample:

select emp#, empName from emp;

-Henry

Re: sql include #

Posted by Eric Blue <er...@gmail.com>.

Henry,

You should be able to escape the column with another #. See:

http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+POUND+or+DOLLAR+symbols+in+my+queries%3F

On 8/11/05, Henry Lu <zh...@umich.edu> wrote:
> 
> How do I use a SQL statemen including a column name with #:
> 
> EXample:
> 
> select emp#, empName from emp;
> 
> -Henry
>