Re: Error when trying to loop through DB and run a script

[mreece]

i suspect the problem is in the PDF code which you did not post. i recommend you trim your PDF Stuff down to something small that still produces the error, and troubleshoot that.

specifically, it appears that your $api object has an undef $api->{pdf} value. are you properly constructing a new PDF::API2 object each time through your while loop?

[ikkon]

you know I probably not, But I thought each time through the pdf objects where distroyed?? I figured out where its failing, just not sure what I am doing wrong, you are probably on to something with the $pdf object, but not sure how to do it here is code where the problem lies:

my $ChartImageName = "$tmpPath/VeTCOChart.png";

setImage($ChartImageName, 110/mm, 165/mm, 95.25/mm, 79.375/mm);

sub setImage{
    my $photo_file=$pdf->image_png($_[0] ,-lossless => 1);
    my $photo = $page->gfx;

    ## add photo to pdf include cordinates and size - image($photo, x,
+ y, width, hieght);
    $photo->image($photo_file, $_[1], $_[2], $_[3], $_[4]);

}

setimage call is where its failing! I open a pdf template so this is how I declare my pdf object.

my $pdf = PDF::API2->open($Template) or print "PDF Object is failing o
+r NULL";
    my $page = $pdf->openpage(1);

thanks for the help

[mreece]

this code appears out of order, perhaps, so i'm not sure what is going on. my guess is that the my $pdf = ... is at file scope, so setImage() is reusing the same $pdf object every time, and it probably shouldn't. consider creating a fresh PDF::API2 object each time through your while loop, and passing it explicitely to the setImage function.

[ikkon]

yep this is it, i declared pdf globaly and it worked, thanks.