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

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

Nov 13, 2002, 8:18 AM
jaspercram
User (150 posts)
jaspercram's avatar
Nov 13, 2002, 8:18 AM
Views: 4682
Shortcut
Quote Reply
Re: [TheStone] Searching Text Fields that aren't NULL In reply to
Hi Stone,

I added
Code:
if (exists $opts->{"$field-null"} and ($opts->{"$field-null"} ne "")) {
push @ins, [$field, 'IS', \'NULL'];
}
to GT::SQL::Base::build_query_cond() (line 499, see attachment) which seems to do exactly what I want.
GT, is this something that you guys want to support in future versions?

Jasper
http://www.bookings.org

Last edited by:

jaspercram: Nov 13, 2002, 8:21 AM

Attached Files:

Subject Author Views Date
Thread Searching Text Fields that aren't NULL jayland 4952 Sep 28, 2002, 2:41 PM
Post Re: [jayland] Searching Text Fields that aren't NULL 		jaspercram 4681 Nov 12, 2002, 5:02 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL 		604 4678 Nov 12, 2002, 1:17 PM
Post Re: [TheStone] Searching Text Fields that aren't NULL 		jaspercram 4661 Nov 13, 2002, 7:16 AM
Post Re: [TheStone] Searching Text Fields that aren't NULL 		jaspercram 4682 Nov 13, 2002, 8:18 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL 		jaspercram 4685 Nov 13, 2002, 7:41 AM
Post Re: [jaspercram] Searching Text Fields that aren't NULL 		jayland 4646 Nov 13, 2002, 8:18 PM