Wednesday, May 30, 2007 04:00 PM
If you add your objects to the Vector with .add(object) then the insert order is maintained and each new item is added to the end of the list. So if you want the 1st row, do a .get(0) from the Vector (zero-based index). A .get(1) gives second row and so on.
Sounds like a Map might work better for you where the value is the database table's row and the key is the primary key value of that row.
I don't really understand the count(*) issue since you will only get one value back from a count(*) query.
Maybe you could provide more detail...