in reply to Re^2: how to store text file information into my sql database
in thread how to store text file information into my sql database

... doesn't work properly

Don't hesitate to elaborate further. What happened then? What did you expect to happen?

Cheers, Sören

Créateur des bugs mobiles - let loose once, run everywhere.
(hooked on the Perl Programming language)

  • Comment on Re^3: how to store text file information into my sql database

Replies are listed 'Best First'.
Re^4: how to store text file information into my sql database
by chella2104@gmail.com (Sexton) on Dec 26, 2015 at 11:20 UTC

    when i run this programme following error was occur DBD::mysql::st execute failed: called with 8 bind variables when 4 are needed

[reply]

      DBD::mysql::st execute failed: called with 8 bind variables when 4 are needed

      You are being very fortunate in getting a descriptive error, telling you what went awry:

      You wrote a programme expecting 4 bind variables. Then you supplied 8 instead. You're programme wants you to help.

      This does not exactly fit the description in the op where 5 of them were used. But still, you went wrong when you split on blank spaces ending up with more variables than you needed. A fix to use unpack instead of split has in the mean time been suggested by poj in Re: how to store text file information into my sql database.

      Cheers, Sören

      Créateur des bugs mobiles - let loose once, run everywhere.
      (hooked on the Perl Programming language)

[reply]

In Section Seekers of Perl Wisdom