Customized Error Message for Insert or Update Records
How can I add custom error messages if an Insert Record or an Update Record fails?
How can I add custom error messages if an Insert Record or an Update Record fails?
You can add form validation. Why would it fail? It is probably best to capture the reason it might fail and give information about why using client or server form validation.
It would fail if the table doesn't allow duplicates and some is trying to add a name that is already in the system.
Our Server Validation server behavior that is included in Data Bridge has a "Check for unique value" validation you could use to show an error message when someone tries to insert a repeated value.
Alternatively you could just add a recordset to the top of the page and filter by the value you don't want to allow repeats and only do the database insert/update if the recordset is empty (no repeats found) and show an error message if it has a result (repeat found).
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.