NHL teams with two-word names

24 views
Skip to first unread message

John Currey

unread,
Dec 17, 2021, 8:28:29 AM12/17/21
to SDQL API
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:


Joe Meyer

unread,
Dec 17, 2021, 9:39:56 AM12/17/21
to sdq...@googlegroups.com
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.
Reply all
Reply to author
Forward
0 new messages