I am still struggling with the same problem, could you please tell me why is
this error :
javax.servlet.ServletException: java.sql.SQLException: Column not found:
Unknown column 'Big' in 'where clause'
The code is like this :
<sql:query>
select * from description where name = <%= request.getParameter("name")
%>
</sql:query>
Thanks
>From: sufi malak <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: jdbc taglib question ?? No rows selected
>Date: Wed, 18 Apr 2001 14:52:58 -0000
>
>Hi, I just read the documentation again, from apache site :
>http://jakarta.apache.org/taglibs/doc/jdbc-doc/index.html#escapeSql
>And I changed the sql quer to :
>
><sql:query>
> select * from description where name =
>'<sql:escapeSql><%=request.getParameter("name")%></sql:escapeSql>'
> </sql:query>
>BUT STILL DOES NOT WORK, ALWAYS I get no rows selected.
>
>
>
>
>>From: sufi malak <[EMAIL PROTECTED]>
>>Reply-To: A mailing list about Java Server Pages specification and
>> reference <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: jdbc taglib question ???
>>Date: Wed, 18 Apr 2001 12:59:47 -0000
>>
>>Hi,
>>1)
>><sql:query>
>> select * from description where name like <%= "'" +
>>request.getParameter("name") + "'"%>
>> </sql:query>
>>2)
>><sql:query>
>> select * from description where name like '<%=
>>request.getParameter("name") %>'
>> </sql:query>
>>
>>Both (1) and (2) don't work.
>>
>>
>>>From: Richard Yee <[EMAIL PROTECTED]>
>>>Reply-To: A mailing list about Java Server Pages specification and
>>> reference <[EMAIL PROTECTED]>
>>>To: [EMAIL PROTECTED]
>>>Subject: Re: jdbc taglib question ?????
>>>Date: Tue, 17 Apr 2001 13:26:57 -0700
>>>
>>>Sufi,
>>>You need single quotes around the string in your like clause.
>>>select * from description where name like '<%=
>>>request.getParameter("name")
>>>%>'
>>>
>>>If that doesn't work you might have to do
>>>select * from description where name like <%= "'" +
>>>request.getParameter("name") + "'" %>
>>>
>>>
>>>-Richard
>>>
>>>-----Original Message-----
>>>From: sufi malak [mailto:[EMAIL PROTECTED]]
>>>Sent: Tuesday, April 17, 2001 1:16 PM
>>>To: [EMAIL PROTECTED]
>>>Subject: jdbc taglib question ?????
>>>
>>>
>>>could you please tell me what's wrong in this line:
>>>select * from description where name like <%=
>>>request.getParameter("name")
>>>%>
>>>
>>>
>>>the file is like this :
>>>..........
>>><%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc" prefix="sql" %>
>>>
>>><% String name = request.getParameter("name"); %>
>>><% out.println(" The name is >>>>>:" + name); %>
>>>
>>><sql:connection id="conn1">
>>> <sql:url>jdbc:mysql://localhost/test</sql:url>
>>> <sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
>>></sql:connection>
>>>
>>><sql:preparedStatement id="stmt2" conn="conn1">
>>> <sql:query>
>>> select * from description where name like <%=
>>>request.getParameter("name") %>
>>> </sql:query>
>>> <sql:resultSet id="rset1">
>>> <pg:item>
>>> <sql:getColumn position="1"/><br>
>>> <sql:getColumn position="2"/><br>
>>>..............
>>>_________________________________________________________________
>>>Get your FREE download of MSN Explorer at http://explorer.msn.com
>>>
>>>===========================================================================
>>>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
>>
>>===========================================================================
>>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
>
>===========================================================================
>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
===========================================================================
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
