In Reply To:
If you aren't using the field for something else, there's always the isPaidLink tag you can use in the templates.
So I got this to work from the templates, but it is not satisfactory for my purposes.
What I need to do is pull all links that are either featured, i.e., IsFeatured = "Yes" or are paid links, and return them all. Ideally I could just update the following Global with an "or" command:
Code:
sub {
# Displays the featured links on each category page.
my ($id,$search_db,$output,$sth,$link);
$id = shift;
$search_db = $DB->table('Links', 'CatLinks');
$search_db->select_options ("ORDER BY Title");
$sth = $search_db->select ( {isFeatured => 'Yes', isValidated => 'Yes', CategoryID=>$id});
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link', $link);
}
return $output;
}
Right now I am selecting all links that are isFeatured, isValidated... I want to also select as part of this all links that are paid and IsValidated.
This seems like it shouldn't be overly complex?