db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: What's the name of a column...
Date Wed, 14 Nov 2007 16:49:31 GMT
Luis Angel Fernandez Fernandez wrote:
>   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.
>   Bye!
That column doesn't have a name unless you write the query as something like

select MAX(idstat) as "maxIdStat" from history

Mark Thornton

View raw message