projects
/
id3fs.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
1e73912
)
NOT: fix left joins
author
Ian Beckwith
<ianb@erislabs.net>
Fri, 15 Oct 2010 00:23:39 +0000
(
01:23
+0100)
committer
Ian Beckwith
<ianb@erislabs.net>
Fri, 15 Oct 2010 00:23:39 +0000
(
01:23
+0100)
lib/ID3FS/Path/Node.pm
patch
|
blob
|
history
diff --git
a/lib/ID3FS/Path/Node.pm
b/lib/ID3FS/Path/Node.pm
index
8ce259e
..
472fe41
100644
(file)
--- a/
lib/ID3FS/Path/Node.pm
+++ b/
lib/ID3FS/Path/Node.pm
@@
-114,12
+114,12
@@
sub node_to_sql
if(defined($node->{parents_id}))
{
$sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
if(defined($node->{parents_id}))
{
$sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
- $sql .= " AND
fxt" . scalar(@joins) . ".tags_
id='" . $node->{id} . "'";
+ $sql .= " AND
t" . scalar(@joins) . ".
id='" . $node->{id} . "'";
}
else
{
$sql= "(t" . scalar(@joins) .".parents_id=''";
}
else
{
$sql= "(t" . scalar(@joins) .".parents_id=''";
- $sql .= " AND
fxt" . scalar(@joins) . ".tags_
id='" . $node->{id} . "'";
+ $sql .= " AND
t" . scalar(@joins) . ".
id='" . $node->{id} . "'";
}
if($not)
{
}
if($not)
{