Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

bind_param error

by Bheema_Tyco (Novice)
on Apr 28, 2010 at 05:24 UTC ( #837227=perlquestion: print w/replies, xml ) Need Help??

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

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://837227]
Approved by GrandFather
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2023-09-29 22:59 GMT
Find Nodes?
    Voting Booth?

    No recent polls found