PDA

View Full Version : easy one!:)



sasha hantz
08-13-2007, 02: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.