Hi all:
I'm trying to generate a intersect statement with variable argument
list, I've tried something like:
...
ltags = ['news', 'publicity']
s = select([tags.c.channel], tags.c.tag == ltags[0])
for tag in ltags[1:]:
s.intersect(select([tags.c.channel], tags.c.tag == tag))
s1 = select([channels.c.channel], channels.c.channel.in_(s))
print e.execute(s1).fetchall()
But this give me wrong results... What's the correct way of doing this
kind of queries?
Thanks.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
