Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

How to get NOT NULL value in a global

Quote Reply
How to get NOT NULL value in a global
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.
Subject Author Views Date
Thread How to get NOT NULL value in a global cassandra 2396 Apr 9, 2002, 1:55 PM
Thread Re: [cassandra] How to get NOT NULL value in a global
Paul 2307 Apr 9, 2002, 2:31 PM
Post Re: [Paul] How to get NOT NULL value in a global
cassandra 2290 Apr 10, 2002, 8:31 AM
Post Re: [Paul] How to get NOT NULL value in a global
Alex 2286 Apr 10, 2002, 12:44 PM