I am attempting to pull info from my database using a couple template fields within XPression. I've been able to get it working when my Logo Code field is set to static using this coding:
SELECT `FIRST` & "" FROM ROSTERS WHERE (`CODE`="@Logo Code@") AND `JERSEY`=0+@Jersey@
Here's the databse:

Here's the working template data:

But when I change the Logo Code to DataLinq, the data no longer pulls:

Any thoughts on what I can do to make this work? I'd like to get some scenes that default to my away/home teams for every show.
------------------------------
Robert Hundley
Chicago United States
------------------------------