in reply to inserting enum column into mysql from Perl program

This means you never declared nor defined $col7. The following is missing from your code: 

my $col7 ;

[download]

Note that $col7 will remain undefined until you set it to something else. DBI will treat undef as NULL while executing SQL statements.

Replies are listed 'Best First'.
Re^2: inserting enum column into mysql from Perl program
by baperl (Sexton) on Sep 25, 2011 at 22:28 UTC
    understood....yes indeed, I had not...let me fix that and see if it works ... thx!
[reply]
      thanks, I fixed that and it works:-)
[reply]

In Section Seekers of Perl Wisdom