How to Iterate through multiple ResultSet Strings

BrollaCarve

New Member
I seem to have having issue getting all values into an arrayList from result set.\[code\]ResultSet rs2 = stat.executeQuery("select date from project_time;"); while (rs2.next()) { al3.add(rs2.getString(1)); } rs2.close();\[/code\]Should be adding all three dates to the arrayList, however it is just adding one date, twice.\[code\][03/17/2013, 03/17/2013]\[/code\]If I run the below SQL directly on the DB I the below results.\[quote\] select date from project_time\[/quote\]\[code\]"03/10/2013""03/17/2013""03/03/2013"\[/code\]I have also tried \[code\]al3.add(rs2.getString("DATE"));\[/code\] with the same results.Where am I going wrong?
 
Back
Top