projects
/
id3fs.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
tags: AND limit clauses together
[id3fs.git]
/
lib
/
ID3FS
/
Path.pm
diff --git
a/lib/ID3FS/Path.pm
b/lib/ID3FS/Path.pm
index
0559463
..
ee8353d
100644
(file)
--- a/
lib/ID3FS/Path.pm
+++ b/
lib/ID3FS/Path.pm
@@
-477,18
+477,18
@@
sub tags
$clause .= " AND tags.id NOT IN (" . join(', ', @values) . ")";
}
$clause .= ")";
$clause .= " AND tags.id NOT IN (" . join(', ', @values) . ")";
}
$clause .= ")";
- push(@
or
clauses, $clause);
+ push(@
and
clauses, $clause);
}
else
{
# print "HASNT VALUES\n";;
if(@used)
{
}
else
{
# print "HASNT VALUES\n";;
if(@used)
{
- push(@
or
clauses, "(NOT (tags.parents_id='' AND tags.id IN (" . join(', ', @used) . ")))");
+ push(@
and
clauses, "(NOT (tags.parents_id='' AND tags.id IN (" . join(', ', @used) . ")))");
}
for my $pair (@used_with_vals)
{
}
for my $pair (@used_with_vals)
{
- push(@
or
clauses, "(NOT (tags.parents_id='" . $pair->[0] . "' AND tags.id='" . $pair->[1] . "'))");
+ push(@
and
clauses, "(NOT (tags.parents_id='" . $pair->[0] . "' AND tags.id='" . $pair->[1] . "'))");
}
}
}
}