I installed the SQL plugin, and created a successful connection to my MySQL database.
I also created a query that does a simple select:
Now, I want to show some rows from that query on the page.
So I created a RepeatingGroup, and chose “get_countries” as the Type of content:
I also created a text field in the RepeatingGroup and configured it as the country’s name (which is a field in my query):
After doing so and loading my preview, my RepeatingGroup is empty.
I also tried playing with the “Data Source” of the RepeatingGroup but couldn’t make it work.
I double check and my sql qurey returns a set of results - it’s not empty.
Any idea what I’m doing wrong?