Register
'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.