resultSet.last() is only available with JDBC 2.0
which last I knew most JDBC drivers were not compliant with
Frank
----- Original Message -----
From: David Mossakowski <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 1999 11:40 PM
Subject: Re: Database Query
> 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
___________________________________________________________________________
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
