Re: inserting enum column into mysql from Perl program

[onelesd]

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

my $col7 ;

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

[baperl]

understood....yes indeed, I had not...let me fix that and see if it works ... thx!

[baperl]

thanks, I fixed that and it works:-)