http://qs321.pair.com?node_id=837227

Bheema_Tyco has asked for the wisdom of the Perl Monks concerning the following question:

hi monks, i am getting the following error when i run my script against sql server

DBD::ODBC does not yet support binding a named parameter more than once

i am bind the parameter here

my $counter = 1; foreach my $key (keys %hdr_field_vars) { my $data_ref = $hdr_field_vars{$key}[0]; my $data = $$data_ref; #print $JBM " counter is $counter \n"; #print $JBM " data is $data \n"; use Data::Dumper; print "<--------------------"; print $JBM Dumper($data); print "-------------------->"; $sth_header->bind_param( $counter, $data ); $counter++; #print $JBM "$counter"."==>"."$data\n"; }

any solution

Replies are listed 'Best First'.
Re: bind_param error
by ikegami (Patriarch) on Apr 28, 2010 at 05:28 UTC
    Just saw this here the other day. You'll find your SQL contains :0 at least twice