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

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

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]);

}
[download]

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);
[download]

thanks for the help

Comment on Re^2: Error when trying to loop through DB and run a script Select or Download Code

Replies are listed 'Best First'.
Re^3: Error when trying to loop through DB and run a script by mreece (Friar) on Apr 03, 2007 at 19:24 UTC
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.	[reply] [d/l] [select]
Re^4: Error when trying to loop through DB and run a script by ikkon (Monk) on Apr 03, 2007 at 19:50 UTC
yep this is it, i declared pdf globaly and it worked, thanks.	[reply]

In Section Seekers of Perl Wisdom