Alex,
I have gotten around to this again and updated this global to look like this:
#show_reviews
my $ID = shift;
my ($output);
my $table = $DB->table('Reviews') || return $GT::SQL::error;
$table->select_options('ORDER BY Review_Date DESC','LIMIT 3') || return $GT::SQL::error;
my $sth = $table->select( { Review_LinkID => $ID } ) || return $GT::SQL::error;
while (my $hit = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('review_link_show', $hit) || return $GT::SQL::error;
}
return $output;
}
Here's the weird thing about it... it built perfectly fine the first time I ran it and the second build gave me the same error again.
Safe swoops
Sangiro
I have gotten around to this again and updated this global to look like this:
Code:
sub { #show_reviews
my $ID = shift;
my ($output);
my $table = $DB->table('Reviews') || return $GT::SQL::error;
$table->select_options('ORDER BY Review_Date DESC','LIMIT 3') || return $GT::SQL::error;
my $sth = $table->select( { Review_LinkID => $ID } ) || return $GT::SQL::error;
while (my $hit = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('review_link_show', $hit) || return $GT::SQL::error;
}
return $output;
}
Here's the weird thing about it... it built perfectly fine the first time I ran it and the second build gave me the same error again.
Safe swoops
Sangiro