String column comparison values have to be surrounded by single quotes in
your sql query.
You would need,
select * from description where name like '<%= request.getParameter("name")
%>'
Note that single quotes within your request.getParameter("name") value would
have to be escaped or the sql query will break.
Rob
----- Original Message -----
From: "sufi malak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 1:16 PM
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
