troubleshooting Question

ASP - Check For Duplicates

Avatar of bschwarting
bschwarting asked on
Microsoft AccessASPSQL
21 Comments1 Solution277 ViewsLast Modified:
What is the EASIEST way to check for duplicates before I do an insert?

The radionumber field is where I need to do the check.

Should I do this in ASP or in the SQL statement?

This is an access database.

mySQL = "INSERT INTO radioGPS ( lastname, streetaddress, radionumber, latitude, longitude, signalstrength, altitude, antennatype, gpsaccuracy, latitude1, latitude2, longitude1, longitude2 ) VALUES ( '" & lastname & "','" & streetaddress & "','" & radionumber & "','" & latitude & "','" & longitude & "','" & signalstrength & "','" & altitude & "','" & antennatype & "','" & gpsaccuracy & "','" & latitude1 & "','" & latitude2 & "','" & longitude1 & "','" & longitude2 & "' )"
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros