ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <steven...@gmail.com>
Subject Re: how to put parameter in the select item
Date Tue, 07 Feb 2006 04:21:50 GMT
Dear Larry,

It's working, thanks so much, but seems the iBatis document didn't describe
"$" usage.

Thanks so much for your warm-heated help.

Steven


On 2/7/06, Larry Meadors <lmeadors@apache.org> wrote:
>
> select $family$,partnum from cto.partfamily
>
> Larry
>
>
> On 2/6/06, stevenlou@gmail.com <stevenlou@gmail.com> wrote:
> > Dear all,
> >
> > Now I write one query, it's like this:
> >  select #family#,partnum from cto.partfamily
> >
> > I want to pass the parameter "family" to the statement, but it always
> return
> > one error(I use DB2 database):
> > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0418N  A
> > statement contains a use of a parameter marker that is not valid.
> > SQLSTATE=42610
> >
> > Seems the database can't accept the parameter in select item, how can I
> > finish this function?
> >
> > Thanks for your warm-heated help!
> >
> > Steven
>

Mime
View raw message