Re: Extra quotes doing SQL insert from Perl to CSV.

[poj]

Use placeholders and always_quote option

#!/usr/bin/perl
use strict;
use DBI;

my $dbh = DBI->connect("dbi:CSV:", "", "",{
   'RaiseError' => 1 }
);  
 
$dbh->{'csv_tables'}->{'MyTable'} = {
 'file'         => 'data1.csv',
 'col_names'    => ["num","id"],
 'always_quote' => 1,
};

my $num = '0123';
my $id  = '0124';
my $sql = "INSERT INTO MyTable VALUES (?,?)";
my $result = $dbh->do($sql,undef,$num,$id);

poj

[JamieJ]

poj, Excellent! That did the trick, particularly 'always_quote' => 1 Thank you so much! -JJ