diff options
| author | ivan <ivan> | 2003-04-01 07:59:53 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-04-01 07:59:53 +0000 |
| commit | d88507e5e19b45eb970e3c2edf6a430262d485be (patch) | |
| tree | 4dae498acb116bc92849ed35d06a3846a7b91b72 /FS | |
| parent | 33849ebe914f0cb3d80c11b039abc52a1dcf94be (diff) | |
- update qsearch for Pg 7.3
- preliminary 1.5.0 upgrade docs
- syntax error in main customer view
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Record.pm | 18 |
1 files changed, 13 insertions, 5 deletions
diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm index 31b6070a3..d783870cc 100644 --- a/FS/FS/Record.pm +++ b/FS/FS/Record.pm @@ -224,19 +224,27 @@ sub qsearch { if ( ! defined( $record->{$_} ) || $record->{$_} eq '' ) { if ( $op eq '=' ) { - if ( driver_name =~ /^Pg$/i ) { - qq-( $column IS NULL OR $column = '' )-; + if ( driver_name eq 'Pg' ) { + if ( $dbdef->table($table)->column($column)->type =~ /(int)/i ) { + qq-( $column IS NULL )-; + } else { + qq-( $column IS NULL OR $column = '' )-; + } } else { qq-( $column IS NULL OR $column = "" )-; } } elsif ( $op eq '!=' ) { - if ( driver_name =~ /^Pg$/i ) { - qq-( $column IS NOT NULL AND $column != '' )-; + if ( driver_name eq 'Pg' ) { + if ( $dbdef->table($table)->column($column)->type =~ /(int)/i ) { + qq-( $column IS NOT NULL )-; + } else { + qq-( $column IS NOT NULL AND $column != '' )-; + } } else { qq-( $column IS NOT NULL AND $column != "" )-; } } else { - if ( driver_name =~ /^Pg$/i ) { + if ( driver_name eq 'Pg' ) { qq-( $column $op '' )-; } else { qq-( $column $op "" )-; |