|
On 05/07/2006, at 9:21 AM, Joe Pluta wrote:
I'm a little confused (not that that's unusual). What do you mean "iteratethrough each column"? The ResultSet in JDBC has a next() method which positions you to the next row, at which point you do getXxx (e.g.,getString, getFloat) passing either an ordinal column number or a String containing a column name to get the appropriate field from the current row.I don't have to iterate through the columns.
You do. Issuing a GetXxx for each column in a row is effectively the same as iterating over those columns, determining the data type, and extracting it accordingly.
Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software AS/400 Technical Specialists http://www.flybynight.com.au/ Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\ Fax: +61 3 9419 0175 \ / X ASCII Ribbon campaign against HTML E-Mail / \ --------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.