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

Replies are listed 'Best First'.
Re^3: how to store text file information into my sql database by Happy-the-monk (Canon) on Dec 26, 2015 at 10:55 UTC
... 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)	[reply]
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]
Re^5: how to store text file information into my sql database by Happy-the-monk (Canon) on Dec 26, 2015 at 12:03 UTC
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]