select name, address from TblPerson
>
> rs.getString("address")
> rs.getString ("name")
>
You can also do it as follows
rs.getString(1) for name
rs.getString(2) for adress
but rs.getString(3) yield error because you have only 2 colums selected.
----- Original Message -----
From: "sajida kalsoom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 12:07
Subject: Re: WHAT ABOUT WITH A "invalid descriptor index error"
> fetch results values in the same order in which they exist in result set
> e.g following causing the invalid descriptor index error :
>
> select name, address from TblPerson
>
> rs.getString("address")
> rs.getString ("name")
>
> cause you have fetched address before the name .
>
> hope you get it.
> ----- Original Message -----
> From: "Miguel Angel Carmona" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 23, 2001 11:40 PM
> Subject: WHAT ABOUT WITH A "invalid descriptor index error"
>
>
> > hi all i wanna make a query, but i have this error:
> >
> > "invalid descriptor index error"
> >
> > i have sqlserver6.0
> >
> > thanks....
> >
> >
> > Get 250 color business cards for FREE!
> > http://businesscards.lycos.com/vp/fastpath/
> >
> >
>
___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> >
>
___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
