Hey Guys,
I’m using the tag module and getting stuck when tags have commas.
The tags are company names and are often formatted as company, LLC
If there is a comma in the tag name then exp:tag:entries returns no results.
Query is
SELECT DISTINCT(e.entry_id) FROM exp_tag_entries AS e LEFT JOIN exp_tag_tags AS t ON e.tag_id = t.tag_id WHERE BINARY t.site_id IN (’1’)AND t.tag_name IN (’Company’, ‘LLP’) AND e.type = ‘weblog’
But Query should be
SELECT DISTINCT(e.entry_id) FROM exp_tag_entries AS e LEFT JOIN exp_tag_tags AS t ON e.tag_id = t.tag_id WHERE BINARY t.site_id IN (’1’)AND t.tag_name IN (’Company, LLP’) AND e.type = ‘weblog’
Any thoughts?
Thanks,
Shawn
