LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id
WHERE serial.serialid IN (
};
if (!@$externalid){
carp "No Order seleted";
return { error => "no_order_seleted" };
}
$strsth .= join( ",", @$externalid ) . ")";
my $sthorders = $dbh->prepare($strsth);
$sthorders->execute;
$template->param(error_claim => $@);
} elsif ( ref $err and exists $err->{error} and $err->{error} eq "no_email" ) {
$template->{VARS}->{'error_claim'} = "no_email";
} elsif ( ref $err and exists $err->{error} and $err->{error} eq "no_order_seleted"){
$template->{VARS}->{'error_claim'} = "no_order_seleted";
} else {
$template->{VARS}->{'info_claim'} = 1;
[% IF error_claim %]
[% IF ( error_claim == "no_email" ) %]
<div class="error">This vendor has no email</div>
[% ELSIF ( error_claim == "no_order_seleted" ) %]
<div class="error">No order selected</div>
[% ELSE %]
<div class="error">[% error_claim %]</div>
[% END %]
-