I am trying to delete from a display page that show all the records with a
delete link for each one.
>From: Richard Yee <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: DBtag (delete) ???????????
>Date: Tue, 18 Sep 2001 08:53:21 -0700
>
>Sufi,
>The code works fine on my machine. I'd suggest verifying what exactly are
>the values for the New_Name fields in your db. You should trim any input
>values received from a form b/c of possible leading and trailing
>spaces. Why don't you see if it can do the select successfully first
>before you try and delete the record?
>
>-Richard
>
>At 02:17 PM 9/18/01 +0000, you wrote:
>>Hi, I spent long time to delete a record from a table using the taglin
>>DBtag
>>from Apache, but it does not work, I don't know what's wrong in this query
>>:
>>
>> delete from pcinfo where New_Name
>>='<%=request.getParameter("newname")%>'
>>
>>Here is the complete code :
>>
>><%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc"; prefix="sql" %>
>><%String deletename =request.getParameter("newname");%>
>><%=deletename%>
>><sql:connection id="conn1">
>> <sql:url>jdbc:mysql://mil2wwds10:3306/test</sql:url>
>> <sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
>></sql:connection>
>><sql:statement id="stmt1" conn="conn1">
>> <sql:query>
>> delete from pcinfo where New_Name
>>='<%=request.getParameter("newname")%>'
>> </sql:query>
>> <sql:execute/>
>></sql:statement>
>><sql:closeConnection conn="conn1"/>
>><% response.sendRedirect("wasDeleted.jsp"); %>
>>
>>
>>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
