http://www.perlmonks.org?node_id=662373


in reply to Re^3: Inserting, update and deleteting a database under conditions
in thread Inserting, update and deleteting a database under conditions

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re^5: Inserting, update and deleteting a database under conditions
by apl (Monsignor) on Jan 14, 2008 at 21:32 UTC
    With use strict; you get the following errors:

    Global symbol "$db" requires explicit package name at /apps/otctest/bi +n/report/xx.perl line 8. Global symbol "$filename" requires explicit package name at /apps/otct +est/bin/report/xx.perl line 11. Global symbol "@data" requires explicit package name at /apps/otctest/ +bin/report/xx.perl line 21. Variable "$data" is not imported at /apps/otctest/bin/report/xx.perl l +ine 24. Global symbol "$data" requires explicit package name at /apps/otctest/ +bin/report/xx.perl line 24. Variable "$data" is not imported at /apps/otctest/bin/report/xx.perl l +ine 26. Global symbol "$data" requires explicit package name at /apps/otctest/ +bin/report/xx.perl line 26.
    The simple fix is

    foreach my $filename (@filenames) {

    I'm not trying to be snarky; what do you think $db and @data are? (The errors are telling you to define them.) Once you do, revised: you're going to start getting errors due to the underlying logical problems in your code.
      Well i frgoto 'my'. Except that when iam trying to print @dbfiles it display to me the numder 28, so i guess my statement concernign @dbfiles is also wrong. I was trying to get the data from columns title and body.

      how can i write that properly and what logical error do you see?

        How does $db get initialized? When you do the INSERT, what values should be in place of the question marks you specified?