problem deleting row from table
[nobr]Hi guys
I am stuck with this query that i am using to delete a row from a table. It doesnt give me any errors but does not delete the requested album.Any suggestions?
<h1><center>DELETE ALBUM</center></h1><BR>
<%@ page language="java" import="java.sql.*, java.io.*" %>
<%
String delete_album=request.getParameter("delete_album");
String sql="DELETE FROM ALBUM WHERE ALBUM='delete_album' ";
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con=DriverManager.getConnection("jdbc:derby://localhost:1527/musicapp","karan","karan");
PreparedStatement ps=con.prepareStatement(sql);
ps.executeUpdate();
%>
[/nobr]

