Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search for field != NULL

Quote Reply
Search for field != NULL
As every year i have some probs with the search. ;-(
This time i nedd something like:

search for "dogs cats" but only if field picture != NULL or != ""

Some ideas?

In help i found only this one:
- filtering
field_name : value # Find all rows with field_name = value
field_name : ">value" # Find all rows with field_name > value.
field_name : "<value" # Find all rows with field_name < value.
field_name-gt : value # Find all rows with field_name > value.
field_name-lt : value # Find all rows with field_name < value.
Quote Reply
Re: [Robert] Search for field != NULL In reply to
And another one:

Say you have a link in more than one cat and search for it;
then normaly you should get :

Cat1
link xyz
...

Cat2
link yxz
...

Cat3
linkyxz
...

But it gives the link only once !!!


May the day come true, when this =)§/"=)/§"?()=ß947ß23823-Search-function will be finally finished?
Quote Reply
Re: [Robert] Search for field != NULL In reply to
Third problem:

If you let search for 50 links, but show only 25 per page;
then you got something like:

Page1:

Cat 1
links
...

Cat2
links ...

Cat3
links
...

but on page 2, you got

Cat2
links
...
Cat3
links
...
Cat4
links
...

Think there is now real perfect sort in the search!
So everything i could do is: let search for only 25 and show 25 on a page.
Quote Reply
Re: [Robert] Search for field != NULL In reply to
As usual nobody say something to the search-problems, seems nobody use it?

Now i have another one: How to exclude a category from search?
Quote Reply
Re: [Robert] Search for field != NULL In reply to
Im really fucked off now; i hardcode the values i want in search.pm, i reindex, i look for ww and ma,
but i always got carwash when looking for car for example. After years and years of using lsql this function is still not functional,
and as usual in all this years noone from GT moves his *** to finally solve this.