NHL teams with two-word names

[John Currey]

Hi,

There seems to be an issue if there is a space in the team name in the NHL. The Flames v. Maple Leafs game is in my database for 20211216.

This SDQL query fails:

• date,team,o:team@date=20211216 and team=Maple Leafs

This SDQL query finds the game:

• date,team,o:team@date=20211216 and team=Maple

There's also an issue with the Blue Jackets. Using just "Blue" doesn't help.

Here are the links:

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%40date%3D20211216+and+team%3DMaple+Leafs&submit=++S+D+Q+L+%21++

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%40date%3D20211216+and+team%3DMaple&submit=++S+D+Q+L+%21++

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%40date%3D20211216+and+team%3DBlue+Jackets&submit=++S+D+Q+L+%21++

[Joe Meyer]

John,

it is always correct to quote team names, like this:

date,team,o:team@date=20211216 and team='Maple Leafs'

You can also use CamelCaseCompletion, like this:

date,team,o:team@date=20211216 and team=ML

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/b8ce278f-f050-466c-8f77-68bf39ad4505n%40googlegroups.com.