'Select count(*) As DefaultValue from users' into text field.  as you can see, it does not work. This is the example SQL provided below the SQL entry field :(

There is also a hidden field 'HiddenID' trying to be filled via SQL - I can't see this field in the page source at all when I display it.

'select userid as QuestionOption,username AS QuestionOptionValue from users where userid >100 and userid < 110' is being used here.  Notice that SQL works in this case.  But if I change the WHERE clause to 'where userid = $(UserID) (or any other field shortname) it is broken.