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.