> How do I get rid of the comma in the first value?
You could try shifting to the left like
shift @columns if (undef $column[0]);
then apply join as you have it.
>Is the database returning a null field in the first
>columns, is that why it's returning a comma?
The answer to this question will avoid your problem
in the first place. What database are you using?
Is it that the first entry is deliberately left null as
is deemed to be the case?
Let the list know on the outcome.
Alfred Vahau
Uni. PNG
----------------------------
Subject: Join problem
Date: Thu, 17 Oct 2002 04:47:41 -0700 (PDT)
From: Vincent Lee <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hello All,
I've got a problem with the JOIN function
I've got a list of columns that gets returned from the
database.
I push the column values into an array and then join
them with a comma. The problem is that JOIN puts a
comma in the first value.
How do I get rid of the comma in the first value?
Is the database returning a null field in the first
columns, is that why it's returning a comma?
join (",",@columns);
=====
Regards,
Vincent
