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
