Hi,

Perhaps you should have a read at Before asking a database related question ... first.

<VBcode>
"which is what is currently used and I want to perform the same thing with perl. "

Also please be aware of what you are posting, your code has a password which may (or may not be) the password to your database.

Hope this helps.

Cheers

Martin

Update: holli has since edited the post replacing the SQL password with a dummy password