See JDBC 2.1 specification, especially java.sql.ResultSet interface maybe something
ResultSet rs = ps.executeQuery(); rs.setFecthSize(5); rs.last(); rs.getString(...); Available only from 2.0 specification. Check your JDBC driver ----- Original Message ----- From: "Gregory Price" <[EMAIL PROTECTED]> To: "JRun-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 15, 2001 6:29 PM Subject: OT: SQL > does anyone know how to get a single row in a select statement in sql > say I want to grab the 5th row in some table regardless of its contense, > i just want the 5th record > any help is appreciated! > Thanks > Greg Price > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
