Re: How to retrieve Insert Into Select From records effected

2002-09-09 Thread Gerald Clark
insert ignore into select from will skip duplicates. Karl J. Stubsjoen wrote: Hello, How can I determin what erros occur from an Insert into select from statement? Namely, I'm looking for any duplicate record errors. It is important to inform the user (in a web browser) whether or not a

How to retrieve Insert Into Select From records effected

2002-09-08 Thread Karl J. Stubsjoen
Hello, How can I determin what erros occur from an Insert into select from statement? Namely, I'm looking for any duplicate record errors. It is important to inform the user (in a web browser) whether or not a particular insert would fail. Must I perform a lookup first, or is there a way to