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 4359 Sep 28, 2002, 2:41 PM
Post Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 4111 Nov 12, 2002, 5:02 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
604 4110 Nov 12, 2002, 1:17 PM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 4094 Nov 13, 2002, 7:16 AM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 4118 Nov 13, 2002, 8:18 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 4120 Nov 13, 2002, 7:41 AM
Post Re: [jaspercram] Searching Text Fields that aren't NULL
jayland 4084 Nov 13, 2002, 8:18 PM