28 Dec
2011
28 Dec
'11
11:06 a.m.
Hi,
I'm trying to use queries such as:
SELECT a, b, c FROM foo WHERE id IN (1, 2, 3)
While it's possible to nest queries with IN:
(:select 'a 'b 'c :from 'foo :where (:in 'id (:select 'd :from 'bar)))
It's not possible to have:
(:select 'a 'b 'c :from 'foo :where (:in 'id (list 1 2 3))
=> Value (1 2 3) can not be converted to an SQL literal.
Would you be ok with lists being converted to (a, b, ...) SQL literals ?
Regards,
--
Nicolas Martyanoff
http://codemore.org
khaelin@gmail.com