, I added speed and efficiency, although, logically speaking, it should have slowed things down by adding another data passthru. Hey, I'm new enough that I'll try anything, and if it works, heck, I'm happy to pass it on. I'm also old enough to keep my mouth shut when someone tells me that what they did worked because I may not know as much as I thought I did .
Vector data = new Vector();
// int numCols = -get the number of columns from the ResultSet metadata
String temp = new String[numCols];
for (int i = 0; i < numCols; i++)
temp = rs.getData(i+1); // ResultSet starts at 1, not 0
Originally posted by Pat Flickner:
Object has getData(), and since everything inherits from Object, ResultSet has getData().
Originally posted by Jim Yingst:
...which was acknowledged in Pat's last message, yes?