I'm trying to delete some records from two different tables.
This is my form:
<form action="DeleteRecord.asp" method="POST">
<input type="hidden" name="Emp_Id" value="<%=rs1("Emp_Id")%>"
<input type="submit" name="Submit" value="Delete" />
After I submit I get the following error message:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'B4537'.
B4537 is the employee number I'm trying to delete from both tables. This is the code of DeleteRecord.asp
myId = Request.Form("Emp_Id")
strSQL = "DELETE FROM Employees1 WHERE Emp_Id=" & myId
strSQL = "DELETE FROM Training_Completion1 WHERE Emp_Id=" & myId
Set conn = Nothing
I would appreciate your help