or do
resultSet.last() // puts cursor on the last row
getRow() // gets row at cursor (last one now)
check the sql package for details on these calls
dave.
jon * wrote:
> > Does anyone know of an easy way to get the last row of a ResultSet?
>
> Yep...use Village...
>
> <http://www.working-dogs.com/village/>
>
> QueryDataSet qds = new QueryDataSet ( connection, "Select * from tablename"
> );
> qds.fetchRecords();
> Record rec = qds.getRecord(qds.size());
>
> the rec object will have the last row. you can then use rec.getValue
> ("column_name") to get the Value object. ie, to get it as a string...
>
> String column_value = rec.getValue("column_name").asString();
>
> i hope that helps.
>
> -jon
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
David Mossakowski [EMAIL PROTECTED]
http://www.dwdog.com/styk 212.310.7275
"I don't sit idly by, I'm planning a big surprise"
F U G A Z I
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
