I turned on SQL debugging and here's the query that is run when I
searched for the string 'mfsl':
Code:
--------------------
SELECT COUNT( * )
FROM tracks me
LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track =
me.id )
LEFT JOIN comments comments ON ( comments.track = me.id )
WHERE ( ( ( comments.value LIKE ? ) )
AND ( ( contributorTracks.role = ? )
OR ( contributorTracks.role = ? )
OR ( contributorTracks.role = ? )
OR ( contributorTracks.role = ? ) ) )
: '%HASH 0X6CE724C%', '1', '2', '4', '5'
--------------------
Looks like 'mfsl' is getting turned into 'HASH 0X6CE724C' for some
reason.
--
JJZolx
Jim
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=35737
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
