Hi All
I am using JRun with IIS. I am connecting to my SQL Server database with JDBC-ODBC.
I have a query where i try to retreive data from 5 tables.
it goes something like this:
select t1.a as field1, t2.b as field2, t3.c as field3
from db1 t1, db2 t2, db3 t3
where t1.x=t2.x and
t2.y=t3.y
when i retrieve the value of field1 thru:
String name = rs.getString("field1") or
String name = rs.getString(1)
I get a sql exception:
SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index.
Theres no problem with the query. The problem seems to be in accessing the value from
the result set.
any pointers will be of great help.....
thanks
Alagu
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
