comma delimited list

I'm moving from MS SQL to mySQL while using perl and dbi. I'm trying to
preform the following statement...

MS SQL
----------------------
DECLARE @EmployeeList varchar(100)

SELECT @EmployeeList = COALESCE(@EmployeeList + ',', '') +
CAST(Emp_UniqueID AS varchar(5))
FROM SalesCallsEmployees
WHERE SalCal_UniqueID = 1

SELECT @EmployeeList AS EmpIDList
----------------------
RESULT

EmpIDList
--------------
22,54,95,78,62

mySQL
----------------------
SELECT (@EmployeeList = COALESCE(@EmployeeList + ',', '') + Emp_UniqueID) AS
EmpIDList
FROM SalesCallsEmployees
WHERE SalCal_UniqueID = 1
----------------------
RESULT

EmpIDList
--------------
(NULL)
(NULL)
(NULL)
(NULL)
(NULL)

I'm trying to get a comma delimited list back from the query, although all I
get back are 5 columns that are all NULL. Can anyone tell me whats going on,
what i'm doing wrong, or possibly suggest another way to create a comma
delimited list in one select statement?

Thanks,
Brian




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org