AW: Dup Key Error Messages

2010-09-07 Thread Thorsten Heymann
Hello Jörg, thanks for your detailed answer. I don't think it a good approach to scan error message texts for automated analysis in an application, this is a race which the application (developer) is bound to lose. Yes sure, but you will consider, it is more than a nice to have to let the

Re: AW: Dup Key Error Messages

2010-09-07 Thread Chris W
On 9/7/2010 3:33 AM, Thorsten Heymann wrote: Yes sure, but you will consider, it is more than a nice to have to let the user know what field he filled incorrectly (e.g. in a webform,...). And it would be nice to this in an automated way. I have to agree. Due to database design issues that

AW: Dup Key Error Messages

2010-09-06 Thread Thorsten Heymann
Not the answer I hoped to get but, thanks Carsten! -Ursprüngliche Nachricht- Von: Carsten Pedersen [mailto:cars...@bitbybit.dk] Gesendet: Montag, 6. September 2010 15:17 An: Thorsten Heymann Cc: mysql@lists.mysql.com Betreff: Re: Dup Key Error Messages On Mon, 6 Sep 2010 15:02:24 +0200,

AW: Dup Key Error Messages

2010-09-06 Thread Thorsten Heymann
No, I think you misunderstood me. I have these keys (in this example) - PRIMARY (id) - UNIQUE (ip_addr) - UNIQUE (print_name) And when of of the UNIQUEs is duplicated, I'll wshow user a message WHAT key is a doublette. Von: Tompkins Neil

Re: AW: Dup Key Error Messages

2010-09-06 Thread Shawn Green (MySQL)
On 9/6/2010 9:10 AM, Thorsten Heymann wrote: No, I think you misunderstood me. I have these keys (in this example) - PRIMARY (id) - UNIQUE (ip_addr) - UNIQUE (print_name) And when of of the UNIQUEs is duplicated, I'll wshow user a message WHAT key is a doublette.