I want to prevent an error in my ASP code if I get a file and try to do an INSERT into the database for a record that already exists. Obviously, I can run a quick query to see if it exists, but is there a better or more simplified way to handle this scenario so it does not happen? If not, I'll just do the obvious. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBScript INSERT - avoid error on duplicate record
- Thread starter TMac42
- Start date
jbenson001
Programmer
I think the only way is the way you stated. First run a query to to see if it exists. It is the only way I have found to do this.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question