1 Reply Latest reply: Apr 18, 2012 4:04 PM by Jason Michaelides RSS

    Assign SQL result to script variable

      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