Gossamer Forum
Home : Products : DBMan SQL : Discussion :

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

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
Subject Author Views Date
Thread Searching Text Fields that aren't NULL jayland 3920 Sep 28, 2002, 2:41 PM
Post Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 3684 Nov 12, 2002, 5:02 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
604 3684 Nov 12, 2002, 1:17 PM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 3667 Nov 13, 2002, 7:16 AM
Post Re: [TheStone] Searching Text Fields that aren't NULL
jaspercram 3691 Nov 13, 2002, 8:18 AM
Thread Re: [jayland] Searching Text Fields that aren't NULL
jaspercram 3693 Nov 13, 2002, 7:41 AM
Post Re: [jaspercram] Searching Text Fields that aren't NULL
jayland 3657 Nov 13, 2002, 8:18 PM