Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [BLOOD] if - Corect?

Quote Reply
Re: [BLOOD] if - Corect? In reply to
Just a small point - NULL and empty are different - it depends how your field is setup. You can see in mysqlman whether the blank fields are empty or null. In either case I think you'll need to use a condition (I think Andy wasn't quite awake Tongue). Something like this:

my $cond = GT::SQL::Condition->new( 'CategoryID', '=', $child_id, 'isValidated', '=', 'Yes' ,'FieldName', 'IS NOT', \'NULL', 'FieldName', '<>', '');
my $sth3 = $link_db->select ($cond);
Subject Author Views Date
Thread if - Corect? BLOOD 1165 Mar 14, 2004, 2:32 PM
Post Re: [BLOOD] if - Corect?
afinlr 1114 Mar 14, 2004, 3:02 PM
Thread Re: [BLOOD] if - Corect?
BLOOD 1103 Mar 15, 2004, 2:10 AM
Post Re: [BLOOD] if - Corect?
Andy 1100 Mar 15, 2004, 3:10 AM
Thread Re: [BLOOD] if - Corect?
afinlr 1086 Mar 15, 2004, 5:55 AM
Post Re: [afinlr] if - Corect?
BLOOD 1082 Mar 15, 2004, 9:08 AM