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]

[951 byte] By [karanJa] at [2007-11-27 8:52:53]
# 1

Unless you have an album with 'delete_album' as its name, then you're not going to delete anything. I think you're looking for something closer to:

String sql = "DELETE FROM ALBUM WHERE ALBUM=?";

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, delete_album);

ps.executeUpdate();

kevjavaa at 2007-7-12 21:09:15 > top of Java-index,Java Essentials,New To Java...
# 2
Thanks champ...it worked! I am such a programming n00b at times
karanJa at 2007-7-12 21:09:15 > top of Java-index,Java Essentials,New To Java...