Did the Delete Sql Command work?

del="DELETE FROM users WHERE user='" & admin & "'"
Conn.execute del

In the same way that I can check if a command or a record exists by checking if objRS.EOF is true, is there a way that I can check if the Delete command exists because it does not return an error if no record matches the criteria that was executed to be deleted!

So how do I know that the operation was successful without having to do a SELECT FROM users WHERE username=blah blah and checking if the recordset is empty? :confused:

Specify the optional second argument to the Execute method, it tells how many records are affected by the query.

dim ctr
ctr = 0
del="DELETE FROM users WHERE user='" & admin & "'"
Conn.execute del, ctr
if ctr = 0 then
response.write "No record(s) deleted"
end if

thanks man... works like a charm