verification on delete statement
Hi
i need a verification on delete statement and am trying to execute this delete using prepareStatement and through parameter passing
the code is given below.plz do let me know the problem with the statement
=============================================================
public void doDelete(RunData data,Context context){
try{
connect();
data.setMessage("Connection Established");
String empName=data.getParameters().getString("row_name");
String tableName=data.getParameters().getString("table_name");
System.out.println("Table and row:>"+empName+" >"+tableName);
System.out.println("Starting to Delete>>>");
int n=delete(tableName,empName);
context.put("record_number",String.valueOf(n));
System.out.println("the Number of rows effected is:"+n);
System.out.println("Connection terminating!!!");
//close();
}catch(Exception e){
System.err.println("Exceptoin caught inside doDelete: "+e);
}
}
===========================================================
the error being displayed is:
Error on deletion :java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' where Name = ''' at line 1"
PLZ DO LET ME KNOW WHAT IS WRONG HERE!!!
