¿cómo podría solucionar este problema? muchas gracias
Cita:
El código que tengo es:Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/eliminar-varios-elementos/eliminar.asp, line 27
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/eliminar-varios-elementos/eliminar.asp, line 27
Código PHP:
<%
'idblog=request.QueryString("idblog")
'set Ob_conn1=server.createobject("ADODB.connection")
'Ob_conn1.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../../Data/bd.mdb") & ";"
'set rs1=ob_conn1.Execute("delete from T_blog where c_idblog="& idblog &"")
'response.Redirect("usuario-mensajes.asp?idusuario='"& usuario &"'")
Dim strDeleteList
'esta linea recupera los checkbox marcados en el formulario
strDeleteList = Request("borrar")
if strDeleteList = "" then
Response.Write "No se ha seleccionado ningún mensaje"
Else
Dim Ob_conn1, SQL2, rs2, SQL3
set Ob_conn1=server.createobject("ADODB.connection")
Ob_conn1.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../../Data/bd-eliminar.mdb") & ";"
SQL2 = "DELETE FROM T_mensajes " & "WHERE c_idmensaje IN (" & strDeleteList & ")"
Ob_conn1.Execute SQL2
SQL3 = "DELETE FROM T_mensajesdestino " & "WHERE c_idmensaje IN (" & strDeleteList & ")"
Ob_conn1.Execute SQL3
'Clean up
Ob_conn1.Close
Set Ob_conn1 = Nothing
'Display to the user that the product have been deleted.
Response.Write Request("Delete").Count & " entries were deleted..."
End If
response.Redirect("usuario-mensajes.asp")
%>