Hello:
On Wed, Jul 20, 2011 at 12:45 PM, Mohan L wrote:
> It trying to store that string into the first column and nothing into
> the subsequent columns. That is why it shows "column cannot be null"
> error messages. Thanks Jim Gibson!!!.
>
> Jim Gibson, I understand the problem, but I not sure
> > 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
>
> If that is really the output from the print statement shown above, then you
> don't have a rows of column data in your @dbdata array elements, you have
> an
> array of scalar string values tha
On 7/20/11 Wed Jul 20, 2011 9:04 AM, "Mohan L"
scribbled:
> On Wed, Jul 20, 2011 at 9:23 PM, shawn wilson wrote:
>
>> On Wed, Jul 20, 2011 at 10:41, Mohan L wrote:
>>
>>>
>>> DBD::mysql::st execute failed: Column 'open' cannot be null at
>>> ./demo.plline 104, line 30.
>>> DBD::mysql::st
On Wed, Jul 20, 2011 at 9:23 PM, shawn wilson wrote:
> On Wed, Jul 20, 2011 at 10:41, Mohan L wrote:
>
> >
> > DBD::mysql::st execute failed: Column 'open' cannot be null at
> > ./demo.plline 104, line 30.
> > DBD::mysql::st execute failed: Column 'open' cannot be null at
> > ./demo.plline 104,
On Wed, Jul 20, 2011 at 10:41, Mohan L wrote:
>
> DBD::mysql::st execute failed: Column 'open' cannot be null at
> ./demo.plline 104, line 30.
> DBD::mysql::st execute failed: Column 'open' cannot be null at
> ./demo.plline 104, line 30.
> DBD::mysql::st execute failed: Column 'open' cannot be
How to insert below data structure in data base?
#!/usr/bin/perl
>
>> use strict;
>> use warnings;
>>
>> my %data = (
>>
>> south => {
>> status => {
>> open => { count => 3 },
>> pws => { count => 3 },
>> wip => { count => 0 },
>> hold => { count => 1 },
>> 're-open' => { count => 0 }
#!/usr/bin/perl
> use strict;
> use warnings;
>
> my %data = (
>
> south => {
> status => {
> open => { count => 3 },
> pws => { count => 3 },
> wip => { count => 0 },
> hold => { count => 1 },
> 're-open' => { count => 0 },
> pwu => { count => 0 },
> openesc => { count => 0 },
>
On 2011-07-14 14:09, Mohan L wrote:
I am trying some thing like to print :
foreach my $line (keys %region_data)
{
print "$line\n";
foreach my $item (keys %{$region_data {$line}})
{
print "$item\n";
}
}
Output :
south
status
total_count
north
status
total_coun
