>Hi everybody,
>
>strSql='delete from CartDetail where ItemID = '+cStr(intItemID)
>set conn = Server.CreateObject("ADODB.Connection")
>conn.open "connection string"
>conn.execute sql, , &H00000080
>
>Question: If we don't have the specific ItemID to delete, what would happen?

What's the value of intItemID in this case?

> And how do we know, if the record was deleted or we didn't have this record to start from?
>
Try

strSql='delete from CartDetail where ItemID = '+cStr(intItemID)' +
  " SELECT @@RowCount"