Script error in asp

[aalqa]

hello
I want to deleter record from my table in database but there is error which is Data type mismatch in criteria expression ,any one has any idea can tell me thank you.

[ArtistScope]

You should post the code for us to see, but I would guess that because you are deleting a row that is identified by ID that you may only have to change the parenthesis, so instead of using

where ID = "' & strID & '"

try using

where ID = ' & strID & '

[aalqa]

Thank you , I get the solution and the solution is near to your solution

WHERE PatientId='" & pid & "'",conn
  %>

the solution was

"SELECT * FROM Patient WHERE PatientId=" & pid,conn
  %>