ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <steven...@gmail.com>
Subject how to put parameter in the select item
Date Tue, 07 Feb 2006 04:13:24 GMT
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