Thanks for the message and help,
It is a framework for a web site.
Do you know which module has edit and insert on the same page?
I just noticed that I need to have insert and edit on the different on the form.
I would like to have user to use one form to insert or edit depends on record exists or not.
I tried to place an insert record on the form which works, but I am unable to have update record works using ColdFusion.
Your help and information is great appreciated,
In principle you could use the same form for insert and update, although I usually use two forms.
You will need to find out whether a record exists and use that value to when applying the SQL, update or insert.
My knowledge of CF goes back more than ten years, and I would be of no use to you. I think it best if you go to a forum that covers CF