Mgiyuk

MySql function returns null everytime I have the following function: (The SQL query works perfectly) CREATE FUNCTION get_participantes (pid INT) RETURNS varchar(255) DETERMINISTIC BEGIN DECLARE par varchar(255); SET par = (SELECT GROUP_CONCAT(mail SEPARATOR ',') FROM users WHERE id IN ( SELECT user_id FROM meeting_participants WHERE meeting_id = pid)); RETURN par; END And I'm trying to get the return of that function in the following procedure: CREATE PROCEDURE google_calendar (p1 varchar(50), p2 INT, p3 varchar(50), p4 varchar(50), p5 varchar(50), p6 varchar(50), p7 varchar(50), p8 varchar(50)) BEGIN DECLARE parti VARCHAR(255); SET @parti = get_participantes(p2); SELECT COALESCE(@parti,"nullpart") INTO @par2; SET @cmd = CONCAT('curl "http://*****:80**/meetings/api/" --data-urlencode "id=',p1,'" --data-urlencode "participants=',@par2,'" --data-urlencode "age...