Re: inserting into mysql single element from an array

[Ian Harisay]

        Are you sure you don't have any spaces after EOF?  Also, if it
is just     bugging out on you, you could rewrite as:my $sql = INSERT
INTO .. (...,...,...) VALUES(?,?,?,...);foreach my $values (@array){ 
$dbh->do($sql,undef,@$values);}Also, don't know if this is your actual
code, but it is a good idea to test     the success of your do call.

>>>xaver biton     <[EMAIL PROTECTED]> 08/31 8:59 pm >>>
Hi,

    I've an Array like this:

@array( [Xaver, Biton, myStrasse,     1, 0725120155],
[Xx, Xy, deineStrasse,     2, ],
[Robert, sky, seineStrasse, 2,04035210,     04035211,[EMAIL PROTECTED] ],
...
)


I     want to insert these values in a mysql DB like:

foreach my $values     (@array) {
$dbh->do(<<EOF, undef, @$values);
INSERT INTO ... (...,...,...) VALUES (?,?,?,...)
EOF
}

but I     ricieve this error:
Can't find string terminator EOF anywhere before     EOF at
myhtmlExtractArray.pl line 176.
Process perl exited with code     255

I've tried any kind of things, no luck.

could someone     make me an example how can achive this.

Thks.

Xaver Biton