Graphics

Hi All,

I wanted to see if anyone could help identify a solution to an issue I'm having. I have a scene for an Out of Town scoreboard that currently takes the name from the data feed and shows it on the graphic. Some names don't appear as we'd like them to (example: UNC appears as North Carolina, when we'd prefer for it to show N. Carolina). Ideally, I'd want this to be achieved through a SQL query in order to keep us from updating the fields twice (once to get the game, once to change the names). Below is the query that I'm using:

SELECT * FROM names WHERE [NCAA_NAME]="%game1home%"

"names" is the table I'm using, "NCAA_NAME" is a column in the "names" table that has all of the names displayed from the out of town scores feed and "game1home" is the datalinq key I've setup to reference what the name of the team is as it appears from the data feed.

I have a different SQL query that works great for datalinq keys that are used for statcrew. Below is the query for that:

SELECT * FROM volleyball_all WHERE [Statcrew_Code]="%stat1%" AND [Cat]="%cat1%"

"volleyball_all" is the table, "Statcrew_Code" is all of the datalinq keys we use and "Cat" is where in the XML tree we'll find the stat (example: kills is in attack>k). This query is successful, so I'm at a loss for why the out of town scores one isn't working.

Any help is greatly appreciated.

Thank you,
Rob

Can you describe or give an example of what you mean by "isn't working"? Are you referring only to the names not appearing as you want, like the UNC/North Carolina example you mentioned? Are there issues with placement or accuracy of the data (names, scores, etc.) used on your scoreboard scene?

I come from a Chyron Lyric/Mosaic background and only just recently began learning XPression. However, I've worked extensively with Lyric's version of XPression's Datalinq keys, called Data Binding, which is essentially the same functional concept. In addition I'm getting my SQL Database Certification (MCSE) and might be able to help you out with the SQL query syntax to some degree. Can you give me a better understanding, and/or examples of what happens to the data when you run the Datalinq SQL query command for your Out of Town scoreboard?

Did you set up the successful Datalinqed SQL query for the volleyball/statecrew graphic differently, in any way, from the Out of Town scoreboard? Which elements on the scoreboard are Datalinqed with the SQL query, text fields only? Do you have any 2D graphics, such as logos or headshots, Datalinqed to the SQL query command?
#XPression

Jennifer,

Thank you for reaching out.

What I mean by not working, is that the query does not return a result. Your last question actually made me think to take the spreadsheet that is working, copy the data from the spreadsheet that isn't working into the working spreadsheet and see if I can get it to work. That did the trick, so I'm guessing I just had something not setup correctly in the School & Team Name spreadsheet.

Thank you for your help-
Rob
#XPression

Jennifer, Thank you for reaching out. What I mean by not working, is that the query does not return a result. Your last question actually made me think to take the spreadsheet that is working, copy the data from the spreadsheet that isn't working into the working spreadsheet and see if I can get it to work. That did the trick, so I'm guessing I just had something not setup correctly in the School & Team Name spreadsheet. Thank you for your help- Rob
#XPression