Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: column count error followed by too few bind variables

by Neighbour (Friar)
on Aug 03, 2011 at 08:55 UTC ( #918206=note: print w/replies, xml ) Need Help??


in reply to column count error followed by too few bind variables

It might have been mentioned here before, but I'll put it as explicitly as possible:

There were 2 errors, the first error you fixed yourself by making sure that `Symbol`,`Company_Name`,`Last_Price`,...,`Mktcap` had the same amount of items as the amount of ?'s in your VALUES-list.

The second error means that mysql now expects values when you execute your query ($sth->execute(@h);). Apparently, your @h contains only 29 values, but there are 43 ?'s that need to be given something (a value or 'undef' if you want it to be NULL).

If you want to fill all the extra columns (that you initially added all those ?'s for) to be NULL, why don't you just do that in your query?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (2)
As of 2022-08-19 07:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?