Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Searching Text Fields that aren't NULL

Sep 28, 2002, 2:41 PM
jayland
New User (4 posts)
Sep 28, 2002, 2:41 PM
Views: 4175
Shortcut
Quote Reply
Searching Text Fields that aren't NULL
Is there a search command that allows you to search records and display them if the text field isn't NULL. I'm not looking for a <%if%<%else%> in the template itself. That doesn't do much good because the same amount of hits are produced. I need something in the search_results URL string and searches based on field containing something (e.g. NOT NULL).

Any suggestions on how this may be accomplished would be great?

Jay
Subject Author Views Date
Thread Searching Text Fields that aren't NULL jayland 4175 Sep 28, 2002, 2:41 PM
Post Re: [jayland] Searching Text Fields that aren't NULL 		jaspercram 3927 Nov 12, 2002, 5:02 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL 		604 3927 Nov 12, 2002, 1:17 PM
Post Re: [TheStone] Searching Text Fields that aren't NULL 		jaspercram 3910 Nov 13, 2002, 7:16 AM
Post Re: [TheStone] Searching Text Fields that aren't NULL 		jaspercram 3934 Nov 13, 2002, 8:18 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL 		jaspercram 3936 Nov 13, 2002, 7:41 AM
Post Re: [jaspercram] Searching Text Fields that aren't NULL 		jayland 3900 Nov 13, 2002, 8:18 PM