Subject | Columns names in resultset |
---|---|
Author | Yves Glodt |
Post date | 2008-08-10T19:45:55Z |
Hello,
see this example:
select C.NAME from CUSTOMER C
when I do rst.getString("C.NAME") it does not work, and the exception
says that the columns name was not found in the result set.
Doing rst.getString("NAME") works.
Is this normal and expected?
This behaviour gives me trouble since I have a query where I do several
left-joins on the same table, with different aliases, and I do not see
how I can differentiate the colum names.
Best regards,
Yves
see this example:
select C.NAME from CUSTOMER C
when I do rst.getString("C.NAME") it does not work, and the exception
says that the columns name was not found in the result set.
Doing rst.getString("NAME") works.
Is this normal and expected?
This behaviour gives me trouble since I have a query where I do several
left-joins on the same table, with different aliases, and I do not see
how I can differentiate the colum names.
Best regards,
Yves