I have "AN_No" in my SQL query. I think if it's not in my result set, then I
should be getting a "Column not found" error right?

Suggestions and comments will be greatly appreciated.

Thanks.

Sol

                -----Original Message-----
                From:   Mark Galbreath [mailto:[EMAIL PROTECTED]]
                Sent:   Tuesday, April 24, 2001 8:19 PM
                To:     [EMAIL PROTECTED]
                Subject:        Re: Newbie Question

                Looks like you do not have a field name in the result set
called "AN_No."

                Cheers!
                Mark

                ----- Original Message -----
                From: "Sol Christopher Gipulan" <[EMAIL PROTECTED]>
                Sent: Tuesday, April 24, 2001 5:43 AM


                > Hello all.
                >
                > Can anyone (pls) help me with my problem in the codes
below. I'm getting a
                > "Invalid Descriptor Index" error in the line "alsoArray
[i][0] =
                > rs.getInt("AN_No");". I know this is very simple, the
first array
                (anArray)
                > have no problem. I just can't find what the error is.
Thanks in advance.
                >
                >                 String[][] anArray;
                >                 anArray = new String[30][];
                >                 int[][] alsoArray;
                >                 alsoArray = new int[30][];
                >                 int i = 0;
                >
                >                         while (rs.next()) {
                >                                 anArray[i] = new
String[2];
                file://create
                > sub-array
                >                                 anArray[i][0] =
rs.getString("AN_ID");;
                >                                 anArray[i][1] =
rs.getString("AN_Name");
                >
                >                                 alsoArray[i] = new int[4];
                file://create
                > sub-array
                >                                 alsoArray [i][0] =
rs.getInt("AN_No");
                >                                 alsoArray [i][1] =
rs.getInt("AN_No1");
                >                                 alsoArray [i][2] =
rs.getInt("AN_No2");
                >                                 alsoArray [i][3] =
rs.getInt("AN_No3");
                >
                >                                 i = i + 1;
                >
                >                         }


___________________________________________________________________________
                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

Reply via email to