Saturday, February 11, 2012
  Search
Support Forum
Customize duplicate key error message?
Last Post 23 Jun 2010 10:00 PM by sitelab. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sitelab
New Member
New Member
Send Private Message
Posts:13


--
25 May 2010 08:59 PM  
We are wondering if there is a way to customize the error message returned when a db table is linked to a form with a unique index on one of the fields and the user submits the form with duplicate data to an existing record. Currently the form returns the following message: "Cannot insert duplicate key row in object xxx with unique index 'IX_UniqueEmail'. The statement has been terminated."  We would like to create a more user friendly message like: "<!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> We’re sorry, the email address provided already exists in our database.  If you wish to subscribe again, please chose another email address."

Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
26 May 2010 11:09 AM  
As you can probably tell he error message comes directly from the database server. What I can do is add a Key in the local resources file and check for a value there and use that instead of the DB server error. Because of the Memorial Day weekend holiday for me this will take up to two weeks to get a minor release out.
sitelab
New Member
New Member
Send Private Message
Posts:13


--
26 May 2010 04:19 PM  
Thanks....that would be MUCH appreciated! Bye the way, your support has been excellent.
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
13 Jun 2010 07:21 PM  
I have Version 2.1.0 ready for release if you would like to test it for me :-)
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 04:30 PM  
Certainly...sorry it took so long to get back to you, I didn't check in for a while. How do I get the code? My email is dgray@sitelab.com. Question: does the forum notify via email of replies?
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 04:40 PM  
Never mind the notification question...my bad, I found it....
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
23 Jun 2010 06:05 PM  
I have added the DNN Rich Text Editor to the choice of Field Types, but have found on Editing a Record the data is not updated because in module edit mode Form Master uses AJAX. Once I resolve this I will make the code available.
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 06:08 PM  
Great...Thanks!
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 06:23 PM  
Any ETA on the code availability? We need this last issue resolved to get the final client payment...Thanks!
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 09:38 PM  
Yes, please send the package you have ready...Thanks!
sitelab
New Member
New Member
Send Private Message
Posts:13


--
23 Jun 2010 10:00 PM  
Got it....Thanks!
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.