i cant tell to your #2 question -but #1
> 1) where are the mistakes in my SQL?
seems fine to me...
What exactly do you want aaa is really aaa or also something like
baaad?
I would open a sqlite shell and run your sql statement with -limit 1
Code:
--------------------
sqlite> select tracks.id from tracks LEFT JOIN comments comments ON
comments.track = tracks.id where comments.value LIKE 'aaa' limit 1;
--------------------
That should show one match.
copy that value
add it in a browserlink
http://lms:9000/trackinfo.html?sess=that_id
you should see a track with the comment aaa
works for me
------------------------------------------------------------------------
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=109334
_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
