SQL: Display a select dropdown NOT Working

Hi

I try to use Payment Form and I just try to create a field SQL (Dropbox), I have a table with all the Baseball teams name and location.
Just to let you know my table have the columns: 1) location, 2) team, and 3) published

I place the query at the Default Values of a SQL field. It is not working, It don't display any value.

SELECT `team` AS `value`, `location` AS `text` FROM `zfd7b_MLB_Teams` WHERE `published` = 1 ORDER BY `location`

Thanks a lot,

Ramon

Hello Ramon

That's strange. Could you please submit a support ticket so that we can check to see what's wrong and get it corrected?

Regards,

Tuan