sasha hantz
08-13-2007, 01:31 PM
response.write "<a href=admin.asp?DELETE=" & objRS.Fields("Topic") & ">delete</a>"
this wass the command for the delete that i use and sent to the page with those lines:
DIM DELETE
DELETE = REQUEST.QUERYSTRING("DELETE")
IF DELETE<>"" THEN
Dim rsDell
SET rsDell = SERVER.CREATEOBJECT("ADODB.RECORDSET")
rsDell.open "DELETE * FROM main where Topic='"&DELETE&"'" , DBCONN, 3, 3
Response.Redirect "admin.asp"
END IF
well...what i'm tring to do it to sign the records id and to point to delelete a record with the same id that was pointed.
i got to mention that when i'm doing the same action with other colmn on from the database i get fine results...but somehow that is niot working with the auto id numbers.
and that is the error i get
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
this wass the command for the delete that i use and sent to the page with those lines:
DIM DELETE
DELETE = REQUEST.QUERYSTRING("DELETE")
IF DELETE<>"" THEN
Dim rsDell
SET rsDell = SERVER.CREATEOBJECT("ADODB.RECORDSET")
rsDell.open "DELETE * FROM main where Topic='"&DELETE&"'" , DBCONN, 3, 3
Response.Redirect "admin.asp"
END IF
well...what i'm tring to do it to sign the records id and to point to delelete a record with the same id that was pointed.
i got to mention that when i'm doing the same action with other colmn on from the database i get fine results...but somehow that is niot working with the auto id numbers.
and that is the error i get
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.