Duplicate data issue

[John Currey]

Hi,

I'm not sure what I did to cause this, but I noticed I have 5 Super Bowls with duplicate records in the database. Here are the first three:

https://s3.sportsdatabase.com/NFL/query.html?sdql=jcurrey.date%2Cjcurrey.team%2Co%3Ajcurrey.team%2Cpoints%2Co%3Apoints%40jcurrey.date+in+%5B20130203%2C20150201%2C20170205%5D&submit=++S+D+Q+L+%21++

I know I can delete the sets of games and then re-add each SB once. My question is, does the best programmer on staff have a trick to remove just one of the games with a duplicate key?

Thanks.

[Joe Meyer]

John and SDQL API Friends,

I see that this was caused by an extra space after the team name for those games.

For example, you had entered one game for the 'Ravens' and one game for the 'Ravens '.

I have removed the extra games and will get my best programmer on protecting against this in the future.

Best regards

Joe Meyer

Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/885a6390-3227-4c7c-ae59-fb545c87a1b1n%40googlegroups.com.

[John Currey]

Thanks Joe!