Exception raised when trying to delete record from database...!

Hi Friends,
I am presently working on a project involving JSP and MSAccess using JDBC-ODBC bridge. I can easily add, modify, view the values. But when i try to delete the same i get the follg. exception
"java.sql.SQLException: [Microsoft][ODBC Microsoft Access 97
Driver]Wrong number of parameters test value"
I don't get it.. Pls. help me to recover from this error.

My Code:
-------
<%@ page language="java" import="java.sql.*,java.io.*" %>
<%! String k=""; String check=""; String DeleteValues() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc

dbc:sara","",""); PreparedStatement ps=con.prepareStatement("delete person where name=?"); ps.executeUpdate(); con.close(); }catch (Exception e) {return e.toString();} return "values deleted from database.."; } %>
<% k=request.getParameter("submit"); if (k.equals("Yes")) { check=request.getParameter("name"); out.println("<body>"+DeleteValues()+"</body>"); out.println("<body>"+check+"</body>"); } %>
With thanks,
prakash.

Hi
You never set the value of you input parameter in your query.
Try this..

This now passes John to the (1st) input parameter denoted by the ?.
Hope this helps.
[This message has been edited by Thomas Paul (edited March 02, 2001).]