mba777 has asked for the wisdom of the Perl Monks concerning the following question:

Hello guys,

i've a problem with storing a multiple value field in a MySQL database.

First of all i will tell you what i'm goinig to do. I will sync all users and contacts from an active directory to a mysql database. So far i've written a script which is doinig that. The only problem is a multi value field in the active directory, named "memberOf". This field sometimes contains more than one value, but only the first value is written to the database. But what i want to do is to write all values from a user/contact in only one mysql column.

I know that I can get all values like this, but the question is, how to write these values in one mysql column?

my @member = $entry->get_value('memberof');

Some help would be really nice. Thanks Andy