It does not work, I think the problem is in this line :
<OPTION VALUE= '<sql:escapeSql><sql:getColumn
position="2"/></sql:escapeSql>'> <sql:getColumn position="2"/></OPTION>
But I can't figure it out , ???
>From: "Karau, Joe" <[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 14:18:02 -0500
>
>try using the query:
>
>select distinct(user) as user from pcinfo order by user
>
>... just using "select disinct user as user from pcinfo order by user"
>is most likely returning a column named "distinct user" I'm not sure if
>that is part of the SQL standard or not, however it is very common among
>relational databases.
>
>
>Joseph Karau
>Kingland Systems
>[EMAIL PROTECTED]
>507-536-3629
>AIM: jkara3629
>
>
>-----Original Message-----
>From: sufi malak [mailto:[EMAIL PROTECTED]]
>Sent: Monday, September 10, 2001 2:09 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Column index out of range ???
>
>
>Here is the code :
>
><FORM NAME="productGoto">
><FONT FACE="Arial,Helvetica" SIZE="-2">
><sql:statement id="stmt1" conn="conn1">
> <sql:query>
> select * from pcinfo order by User
> </sql:query>
> <%-- loop through the rows of your query --%>
> Select By User:
><SELECT NAME="productList" onChange="gotoFunction()" onBlur="return
>options[0].selected = true">
> <OPTION VALUE=" "> Users >> </OPTION>
> <OPTION VALUE="ALL">All </OPTION>
> <sql:resultSet id="rset2">
> <OPTION VALUE= '<sql:escapeSql><sql:getColumn
>position="2"/></sql:escapeSql>'> <sql:getColumn position="2"/></OPTION>
> </sql:resultSet>
></SELECT>
></sql:statement>
></FORM>
>
>It works fine with "*" (And I got duplication fields in the drop down
>list)but when I put
> select distinct User from pcinfo order by User I got the error :
>Column index out of range.
>
>thanks.
>
>
>
> >From: "Karau, Joe" <[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:37:30 -0500
> >
> >What's the code for where you build your SQL, retrieve the columns after
> >executing the query, and the table definition(s) for the table(s) that
>you
> >are querying?
> >
> >Joseph Karau
> >Kingland Systems
> >[EMAIL PROTECTED]
> >507-536-3629
> >AIM: jkara3629
> >
> >
> >-----Original Message-----
> >From: sufi malak [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, September 10, 2001 1:36 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Column index out of range ???
> >
> >
> >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
>
>
>_________________________________________________________________
>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
