Hi all, i just try to select some Links, where one field has a def value and another which should have any value but not be empty.
Try to find something about in docu, find a lot of examples but not this one.
my $sth = $cat_db->select ( ['Links.ID','Links.Aufmacher','Links.Logo'], { FatherID => '1'}, {Logo => '?????'} );
I want to have: select from .... where FatherID='1' AND Logo <> ''
or where FatherID = '1' AND Logo = 'Anything, but not empty'
Robert
Try to find something about in docu, find a lot of examples but not this one.
my $sth = $cat_db->select ( ['Links.ID','Links.Aufmacher','Links.Logo'], { FatherID => '1'}, {Logo => '?????'} );
I want to have: select from .... where FatherID='1' AND Logo <> ''
or where FatherID = '1' AND Logo = 'Anything, but not empty'
Robert