DA 207 database error handling

in MySql I set up an index with the attribute of "unique" on one of the columns to keep from getting duplicate entries. It works as it should and when I enter a dupe the Insert.php DA 207 Wizard handles the error with the rather cryptic:

Duplicate entry 'books' for key 2

where "books" is the duplicate word I tried to add.

Usually in php I see lines of code dealing with error handling but I don't see where this command is generated. I suppose this is coming from SSI but I can't backtrack far enough to locate the code and put a more user friendly message in.

Any ideas?

Rick

This looks like the error generated by MySQL. The code written by DataAssist will have the query to insert like this:
mysql_query(<query here>) or die(mysql_error());

If there's an error, then it displays the mysql_error(). If you wanted to output something other than the default mysql_error, you would want to check the mysql_errno() and output different messages based on the error number that is returned.

For that particular error, the error number is 1062:
error-messages-server.html

As this is something that requires custom coding, it is not supported, so I can only point you in the right direction.

JW, okay I understand. But I'd think this is a rather common problem (preventing duplicates in a database). Is there a more elegant way to trap these that I'm not seeing?

How would WA suggest this be done?

Using the error code that is returned by MySql as I suggested in the previous post would be what I would recommend.

Okay, just checking. I'm famous for bulling ahead with the least elegant solution. my last shop was cold fusion/ms sql, so data error trapping was a bit easier/different.

thanks.

No problem. If you run into any additional issues, feel free to open a new thread.