"Randy Layman" <[EMAIL PROTECTED]> scritti il 17/11/2006 15:39:24
>
> I think your problem might be that your SQL doesn't have a
> result column ELEMENTO. I believe you should change your SQL to:
> select
> TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID
> from TIPI_DATO_RIGA
You might need to do this:
select elemento - 1 as elemento, ...
sometimes databases rename these calculated columns.
If you run the query in the Squirrel SQL client you can see exactly what's
happening.
Jeff Butler
On 11/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all
The foll
s the correct column name in the meta
data.
Randy
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 17, 2006 9:34 AM
To: user-java@ibatis.apache.org
Subject: select list: expression values
Hi all
The following SQL map and
Hi all
The following SQL map and query
select
TIPO_RIGA_ID, ELEMENTO - 1, NOME, TIPO_ELEMENTO_ID
from TIPI_DATO_RIGA
where tipo_dato_id = #id:INTEGER#
raises t
