p: appears to be failing

10 views
Skip to first unread message

John Currey

unread,
May 18, 2022, 1:54:15 PMMay 18
to SDQL API

Joe Meyer

unread,
May 18, 2022, 2:45:25 PMMay 18
to sdq...@googlegroups.com
John and SDQL API Friends,

To troubleshoot it is better to use date, which is required, rather than season, which may be missing or erroneous,

Please have a look at the results of this SDQL:

team,date,double header,site,season,runs,p:runs@team=Giants and GimmeTheDog.date>20220301

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/5cf61bb0-b4bd-4f1d-a699-ccfffa8837a9n%40googlegroups.com.

John Currey

unread,
May 18, 2022, 6:46:23 PMMay 18
to SDQL API
Thanks Joe. It appears date, t:team, o:team, and double header are the same, and there are duplicate records. However, I've fallen in this hole previously, and I'd bet I have trailing spaces on my team names. If your best programmer is inclined to not allow me to shoot myself if the foot in the future, that would be great. I'll do my best to make sure my trailing spaces are cleaned up before submitting my data. 

May17.PNG

Reply all
Reply to author
Forward
0 new messages