Re^4: Inserting, update and deleteting a database under conditions

[Nik]

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

[apl]

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.

[Nik]

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?

[apl]

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