On Thu, Sep 18, 2003 at 08:20:00AM -0700, Scot Campbell wrote: > O.K., I understand. And I have always coded in this manner. > > Throw the data at the system and see if it sticks. In most cases it will. > > However, when it does fail, it would be nice to determine the error w/o > issuing more calls.
Agreed. > So, the school solution is, "When a unique constraint is violated, issue > selects for each of the unique contrained columns to determine which one was > violated"? Yup. That's all you can do, aside from parsing the error... -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 181,918,749 queries (453/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]