Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

what this error mean

what is this error mean DBD::PgPP::st execute failed: Wrong number of bound parameters at ...
0
tankergoblin
Asked:
tankergoblin
  • 2
1 Solution
 
arnoldCommented:
Means that you passed the wrong number of items.
I.e. it seems as though you have prepared a dynamic query, but when executing you provided one item less than required.
That is just one possible explanation.
Post the query, and the solution might be obvious.

0
 
tankergoblinAuthor Commented:
what does it mean by wrong number of items...
i want to read file content to database
is that mean the column field name is not match with the name in database?
0
 
arnoldCommented:
You have not posted the query so it is hard to say.
No, it means that you have may have more columns, than values or the other way around.
(column1,column2) values (value1)
or
(column1,column2) values (value1,value2,value3)

Post the query and it might be clearer.

Alternatively, you may have values (value1,value2,value3), but the table into which the data is being inserted only has two columns.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now