deleting rows in database

[ronlahav]

hi all
i have table in which for each row i populate records from mdb file through Sql code in asp. however my question is how to delete records from the database? the very good sample for what i want is in hotmail / yahoo - when u want to delete mail you mark it with check box and then press delete. how do i do that
regads and thanks

Ron

[davebat]

USE SQL THE SAME WAY WOULD TO POPULATE BUT A DELTE COMMAND. EXAMPLE:

DELETE FROM TABLE WHERE UNIQUE_ID='0000001'"

[ronlahav]

ok
so i use sql and delete after finding the PK but how i identify the appropriate PK after the user pressed the checkbox in the current row. i should link somehow between the checkbox and the PK. and thats is my problem.
i can add hidden col to the table which contains the PK but still i dont know how to identify the current row.
thanks for any reply

[davebat]

whats a PK? and what do you mean by current row?

[ronlahav]

hi
the pk is the primary key of the record which i want to delete
the current row is the row actually which i eant to delete. the one on which i marked with the check box