[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index

[leonard]

I use a resultset in java to get the data from a table but I get this error
this is my code:

Code:

     rs.getString("lastname");
     rs.getString("firstname");

and the error:

Code:

[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index

any ideas?

[leonard]

I have found out what the error is.
When we use a ResultSet object to get the date please note:
if we use: ResultSetobject.getString("Name of column") we should place these statements in order of the column designed in our database. For example:
You have 5 columns namely: Field1, Field2, Field3, Field4, Field5.
If you get them by NAME you should get them in order: The following code will give error:

Code:

     rs.getString("Field2");
     rs.getString("Field1");

It should be like this:

Code:

     rs.getString("Field1");
     rs.getString("Field2");