I have a form in coldfusion when I filled the form, it will add the entry to the database. I would like to change it that it will replace my entry in the database.
user_id ID_number firstname lastname contactme
11 ABC Jim Loyal NO
11 ABC Jim Loyal YES
So my first entry was no then yes... So i would like to have only one entry for Jim. How I can change the insert script below...