I'm trying writing a wiki plugin that includes the ability to filter by a list of tags.
I need something that can process the following types of queries:
SELECT *
FROM Tags
WHERE Tags.sTag IN (@sTag1, @sTag2, @sTag3, ...)
and the alternate query
SELECT *
FROM Tags
WHERE Tags.sTag = @sTag1
OR Tags.sTag = @sTag2
OR Tags.sTag = @sTag3
I can't seem to figure out how to write such a query using the CSelectQuery object. What am I missing?
