error while retrieving data from data base

[kirtesh4u]

hi all...

In my one program of java i am reriving data from the MS access database....
my table structure is :
Slno :- Autonumber
Date :-Date/time
Co_no :-number
Acc_name :-text
Tr_type :-text
Amt :-number


and My code is :---
--------------------
Connect c3=new Connect();
ResultSet r3;

r3=c3.stmt.executeQuery("select max(Date) from Transaction");
r3.next();
String temp=r3.getString(2);
System.out.println("temp="+temp);
---------------------------
Connect is class where i hav written the connectio statments and its working fine.

and my error is-----------
java.sql.SQLException: [
icrosoft][ODBC Microsoft Access Driver]Invalid descriptor index
--------------------------------------------------------------
please can you tell me what is the wrong in this...
thank you

[masijade]

You're only selecting one column, but are attempting to retrieve information from column 2?

What did you expect?

[losintikfos]

Change this:
String temp=r3.getString(2);

TO:
String temp=r3.getString(1);

[kirtesh4u]

Date is my second column only so i am using getString(2);

[masijade]

Like I said, this

r3=c3.stmt.executeQuery("select max(Date) from Transaction");

is only selecting one column, so how is Date the second column?

If "Date" were the second column your query would look something like this

r3=c3.stmt.executeQuery("select bogus, max(Date) from Transaction");

So once again, what did you expect? How did you figure that "Date" was the second column when you're only selecting one?

If your talking about your table description, then, I hate to break it to you, but it doesn't work that way. The column numbers apply to the columns selected in the query.

[kirtesh4u]

ok ok i got my mistake
thank you....