On Wed, Jul 20, 2011 at 9:23 PM, shawn wilson <ag4ve...@gmail.com> wrote:
> 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 //= "";
>
for my $datum (@dbdata)
{
print "$datum\n";
}
Output :
east,0,0,2,4,0,0,0,6
north,0,0,7,3,0,0,0,10
south,3,0,1,3,0,0,0,7
west,7,0,0,0,0,0,0,7
But the below code does not work :
for my $datum (@dbdata) {
$query_handle->execute(@$
datum);
}
>
> 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.
>
How to do that using dbic? any example will help.
Thanks & Rg
Mohan L
