The problem is not with the query but how you are handling the result
set. You are referencing a column # or name that doesn't exist. The code
would help as we are not psychics.
-Richard
At 06:35 PM 9/10/01 +0000, you wrote:
>No, it's not like that, because I am trying the qyery from the command line
>of Mysql and it works, but not in jsp file.
>thanks
>
>>From: Satyanarayan Divakar <[EMAIL PROTECTED]>
>>Reply-To: A mailing list about Java Server Pages specification and
>>reference <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: Column index out of range ???
>>Date: Mon, 10 Sep 2001 13:04:56 -0500
>>
>>That means u are referring to a cloumn that is not present in the result
>>set
>>you have obtained..
>>
>>-----Original Message-----
>>From: sufi malak [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, September 10, 2001 1:04 PM
>>To: [EMAIL PROTECTED]
>>Subject: Column index out of range ???
>>
>>
>>Could you please tell me what this error means :
>>
>>Error: 500
>>Location: /pcinfo/pager-jdbc.jsp
>>Internal Servlet Error:
>>
>>javax.servlet.ServletException: java.sql.SQLException: Column index out of
>>range.
>>
>>
>>Thanks
>>
>>
>>_________________________________________________________________
>>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>>DIGEST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>>DIGEST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>http://java.sun.com/products/jsp/faq.html
>http://www.esperanto.org.nz/jsp/jspfaq.html
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
