You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently sqlpage functions are executed before the query is sent to the database, and their output is sent to the database.
To use a value from the database as input in a sqlpage function, one needs to define a variable:
set $x = (select x from y where id =123);
selectsqlpage.some_function($x);