(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [Andy] No NOT IN option for GT::SQL?: Edit Log

Here is the list of edits for this post
Oct 11, 2013, 8:24 AM
el noe
User (434 posts)
Oct 11, 2013, 8:24 AM
Views: 5417
Re: [Andy] No NOT IN option for GT::SQL?
So if Adrian or someone else from GT is going to read this we are suggesting to change in Condition.pm:

Code:
# Perl: column => '!=' => [1,2,3]
# SQL: NOT(column IN (1,2,3))
elsif ($op eq '!=' || $op eq '<>' and ref $val eq 'ARRAY') {

to:

Code:
# Perl: column => '!=' => [1,2,3]
# SQL: NOT(column IN (1,2,3))
elsif (uc $op eq 'NOT IN' || $op eq '!=' || $op eq '<>' and ref $val eq 'ARRAY') {

My Perl is too weak to know if it has to be:
Code:
# Perl: column => '!=' => [1,2,3]
# SQL: NOT(column IN (1,2,3))
elsif ((uc $op eq 'NOT IN' || $op eq '!=' || $op eq '<>') and ref $val eq 'ARRAY') {

with three parameters, but I guess that or will be ok for two "||" without a bracket as well.

Regards

Niko

Last edited by:

el noe: Oct 11, 2013, 8:29 AM

Edit Log: