I need a global to show a custom field i added to the links table.

Im new to this so bear with me. :)

The field is called "localfile" inside the links table, i need a global that shows the Title linked to the "localfile" field instead of the URL (which will be null when localfile is not null).

The localfile field is sometimes EMPTY (null) so also need to validate when localfile is <>''.

The global will be used to show the latests "localfiles" (top10 by add date desc)

Thanks in advance, Rob

I just created a global but it is not working right.

Even though im searching where localfile is not NULL, im getting a resultset were the localfile is null...whats wrong with the syntax?

sub {
# Displays NEW TECH links .
my ($output,$sth,$link);
my $id = shift;
my $db = $DB->table ('Links');
$db->select_options ('ORDER BY ADD_DATE DESC', 'LIMIT 5');
require GT::SQL::Condition;
my $cond = GT::SQL::Condition->new( 'localfile', 'IS NOT', \'NULL');
my $sth = $db->select ($cond);
my $premium;
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('linx', $link);
}
return $output;
}

Solved, had to use <> '' instead of not null