On Wed, Jul 20, 2011 at 10:41, Mohan L <l.mohan...@gmail.com> wrote: > > DBD::mysql::st execute failed: Column 'open' cannot be null at > ./demo.plline 104, <CSV> line 30. > DBD::mysql::st execute failed: Column 'open' cannot be null at > ./demo.plline 104, <CSV> line 30. > DBD::mysql::st execute failed: Column 'open' cannot be null at > ./demo.plline 104, <CSV> line 30. > DBD::mysql::st execute failed: Column 'open' cannot be null at > ./demo.plline 104, <CSV> line 30. > > I am hanging on this issue. Any help will be really appreciated. >
not sure what your table looks like. however, if you want to be able to not have any data in a column, you need to allow the column to be null. you should also do something like: $data = $column //= ""; also, since your data is already a hash, you could just use dbic and define a resultset to allow your data to be imported instead of refactoring it. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
