>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"
--sb--