pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
does the 7.0.2 JDBC driver support absolute() 2+ messages / 2 participants [nested] [flat]
* does the 7.0.2 JDBC driver support absolute() @ 2000-11-01 16:45 matthew denner <matt@evtechnology.com> 0 siblings, 0 replies; 2+ messages in thread From: matthew denner @ 2000-11-01 16:45 UTC (permalink / raw) To: pgsql-interfaces Dear all, i have been trying to use the ResultSet.absolute() call with no success so i'm mailing to find out if this is supported. if it isn't then why is the code present in absolute()? why does absolute() return true for valid rows and false for invalid rows? and why can i do beforeFirst() to move before the first line? Cheers, Matt ----------------------------------------------------------------------------- Sessami is a trademark of Escape Velocity Technology Mobile Services Limited. All information contained in this e-mail is confidential and for the use of the addressee only. If you receive this message in error please notify. ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: does the 7.0.2 JDBC driver support absolute() @ 2000-11-01 16:56 Peter Mount <petermount@maidstone.gov.uk> 0 siblings, 0 replies; 2+ messages in thread From: Peter Mount @ 2000-11-01 16:56 UTC (permalink / raw) To: 'matthew denner' <matt@evtechnology.com>; pgsql-interfaces Yes, it's been supported for some time, although there are some problems. Just browsed the source and I can see a problem where: index<0 then it moves the current row to the index row from the end. index<numrows then it moves to that row. However, the second rule also matches <0, so it takes precedence and we end up moving to row index-1 regardless. Not the required result. I'm fixing it in cvs now. Anyhow, absolute should return true if the row exists, but false if it doesn't (ie ==0 or > num rows in resultset). Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: petermount@maidstone.gov.uk WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council -----Original Message----- From: matthew denner [mailto:matt@evtechnology.com] Sent: Wednesday, November 01, 2000 4:46 PM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] does the 7.0.2 JDBC driver support absolute() Dear all, i have been trying to use the ResultSet.absolute() call with no success so i'm mailing to find out if this is supported. if it isn't then why is the code present in absolute()? why does absolute() return true for valid rows and false for invalid rows? and why can i do beforeFirst() to move before the first line? Cheers, Matt ---------------------------------------------------------------------------- - Sessami is a trademark of Escape Velocity Technology Mobile Services Limited. All information contained in this e-mail is confidential and for the use of the addressee only. If you receive this message in error please notify. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-01 16:56 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-11-01 16:45 does the 7.0.2 JDBC driver support absolute() matthew denner <matt@evtechnology.com> 2000-11-01 16:56 RE: does the 7.0.2 JDBC driver support absolute() Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox