Re: What's the name of a column...

[Bryan Pendleton]

  I execute a query like this: select MAX(idstat) from history;

  Now, from the ResultSet, how can I get the data by column name?

Try using the "as" keyword to provide a name for your column:

  select max(idstat) as max_idstat from history;

Then you should be able to fetch the data by column name "max_idstat".

thanks,

bryan