I would like to get all rows where value is NOT NULL from a field in links table,
example : Check XYZ Field below
sub {
# Displays the newest links on the home page.
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC Limit 10');
$sth = $search_db->select ( { xyz => IS NOT NULL, isValidated => 'Yes' });
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link1', $link);
}
return $output;
}
( xyz => IS NOT NULL ) This is giving me error,
What is the syntax to get fields of NOT NULL,
Thanks in Advance.
example : Check XYZ Field below
sub {
# Displays the newest links on the home page.
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC Limit 10');
$sth = $search_db->select ( { xyz => IS NOT NULL, isValidated => 'Yes' });
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link1', $link);
}
return $output;
}
( xyz => IS NOT NULL ) This is giving me error,
What is the syntax to get fields of NOT NULL,
Thanks in Advance.