hi,
I am trying to execute the following command in my Perl program
my $ins_rec = "INSERT INTO $tbl_name (col1, col2, col3, col4, col5, co
+l6, col7) VALUES (?,?,?,?,?,?,?);";
$sth=$dbh->prepare($ins_rec) or die $dbh->errstr;
$sth->execute($col1, $col2, $col3, $col4, $col5, $col6, $col7) or die
+$sth->errstr;
in my table, col7 is described as
col7 ENUM('N','Y') NOT NULL DEFAULT 'N'
however, when I execute the program, I get the following error:
Global symbol "$col7" requires explicit package name at test.pl line 9
+6.
Execution of test.pl aborted due to compilation errors.
of course, when I remove col7, my program works fine. So, how do I fix the statement so I can insert col7 into my table.
thanks!