Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to assign the result of an SQL request in a script variable:
SET var='';
SELECT CONCAT(id,';') AS idlist
FROM table;
How do I assign idlist value (for example '1;5;7;10') to var?
I tried var=idlist but get an empty result.
Thanks
LOAD
idlist
;
SQL SELECT
CONCAT(id,';') AS idlist
FROM table;
LET var = Peek('idlist');
This will place the last loaded value of idlist into the variable 'var'.
Hope this helps,
Jason