Re: Fw: Weird case : Mysql can not accept insert data from perl!! PLEASE - HELP!!]

This has worked for me
===========================================
($sth = $dbh->prepare( q{
INSERT INTO file (name,address1,....) VALUES (?, ?,...)}));
open FH, " while () {
chop;
my ($name,$address1,.....) = split /&&/;
$sth->execute($name,$address1,...);
}
close FH;
===========================================
HTH

Howard

--
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