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

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