Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

column count error followed by too few bind variables

by baperl (Sexton)
on Aug 02, 2011 at 21:36 UTC ( #918140=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use DBIx::Simple;
    use SQL::Abstract;
    
  2. or download this
    my $q = "INSERT INTO history (`Symbol`,`Company_Name`,`Last_Price`,...
    +...,`Mktcap`) VALUES (?,?,?,STR_TO_DATE(?,\'%m/%d/%Y'),TIME(?),?,?,?,
    +?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
    +)";
    
  3. or download this
    DBD::mysql::st execute failed: Column count doesn't match value count 
    +at row 1 at rtd.pl line 62.
    
  4. or download this
    DBD::mysql::st execute failed: called with 29 bind variables when 43 a
    +re needed at rtd.pl line 65.
    
  5. or download this
    
    $sth = $dbh->prepare($q) or die $dbh->errstr;
    ...
        $sth->execute(@h);
      }
    }
    

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2022-08-18 19:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?