Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Random link global

(Page 2 of 2)
> >
Previous ThreadNext ThreadPrint ThreadView Threaded
May 13, 2003, 11:38 AM
xpert
User (277 posts)
May 13, 2003, 11:38 AM
Post #26 of 28
Views: 2306
Shortcut
Quote Reply
Re: [Paul] Random link global In reply to
Actually I'm using:

my $cond = GT::SQL::Condition->new('Banner', 'IS NOT', \'NULL', 'isValidated', '=', 'Yes');
May 13, 2003, 3:03 PM
afinlr
Veteran (1921 posts)
May 13, 2003, 3:03 PM
Post #27 of 28
Views: 2245
Shortcut
Quote Reply
Re: [xpert] Random link global In reply to
IS NOT NULL and <> '' are different - I think perhaps in this case you need the <> ''
May 13, 2003, 4:41 PM
Paul
Veteran (19537 posts)
May 13, 2003, 4:41 PM
Post #28 of 28
Views: 2248
Shortcut
Quote Reply
Re: [xpert] Random link global In reply to
IS NOT NULL will work assuming your column is NULL unless it has a value.

'' is empty, an empty string, which is different to NULL.
> >
Previous ThreadNext ThreadPrint ThreadView Threaded