I have a database named 'sfntcweb'. There is a table in it called 'dbo.Brands'. I want to return all rows in this column (in dbo.Brands) called 'Name'.
So my SQL query to be used in Dynamic Forms is . . .
SELECT Name AS QuestionOption, Name AS QuestionOptionValue FROM sfntcweb.dbo.Brands Order By QuestionOption
It works on my local dev PC, but when I tried this on my dev server (which has the exact same DNN and DB set up), the SQL code returned the message "Error in SQL!"
Can someone point out what am I missing when I am trying to do it on this server?
Thanks for any insights!
JennC