Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jayland] Searching Text Fields that aren't NULL

Quote Reply
Re: [jayland] Searching Text Fields that aren't NULL In reply to
Hi jayland,

I might have a solution for your problem (but not for mine Frown). If you know a value that your records cannot have, you can search for all entries where the value is not equal to that given value and you will get all entries with not null values. Hmm, hard to explain. Crazy
Let me give you an example. Let's say your table has a field called 'modification_date', which tracks when an entry has been changed and you are sure none of the entries will have '1990-02-27' as modification date. A search for
Code:
...&modification_date=!1990-02-27&...
would give you all entries that are not null.

Hope this works for you (I didn't test it).

Jasper

http://www.bookings.org
Subject Author Views Date
Thread Searching Text Fields that aren't NULL jayland 3919 Sep 28, 2002, 2:41 PM
Post Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 3682 Nov 12, 2002, 5:02 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
604 3682 Nov 12, 2002, 1:17 PM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 3665 Nov 13, 2002, 7:16 AM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 3689 Nov 13, 2002, 8:18 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 3692 Nov 13, 2002, 7:41 AM
Post Re: [jaspercram] Searching Text Fields that aren't NULL
jayland 3655 Nov 13, 2002, 8:18 PM