you'll probably want to put the <%= request.getParameter(name) %> in single
quotes, and use wild card characters.
example:
select * from [table name] where [column name] like '<%=
request.getParameter(name)%>[rdbms wild card]'
this would find any results where the column name had a value that started
with the parameter, it will be able to make use
of an index, if one is built on the column name. However, if you would like
to find records where the parameter
is found anywhere within the value of the column name put the wild card
before the parameter as well. (index won't be used though)
Joseph Karau
Kingland Systems
[EMAIL PROTECTED]
507-536-3629
AIM: jkara3629
-----Original Message-----
From: sufi malak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 3: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
