db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kurt Huwig <k.hu...@iku-ag.de>
Subject Re: What's the name of a column...
Date Wed, 14 Nov 2007 16:54:38 GMT
Am Mittwoch, 14. November 2007 schrieb Luis Angel Fernandez Fernandez:
>   Hi!
>   I execute a query like this: select MAX(idstat) from history;
>   Now, from the ResultSet, how can I get the data by column name?
>   Using rs.getString() with idstat, MAX(idstats)... I get column not
> found. There is an idstat field. What's the name for that kind of
> columns? I did some searches with no success.

SELECT MAX(idstat) AS m FROM history;

then request "m"
Mit freundlichen Grüßen

Kurt Huwig

GnuPG 1024D/99DD9468 64B1 0C5B 82BC E16E 8940  EB6D 4C32 F908 99DD 9468

View raw message