On Fri, Oct 21, 2011 at 5:54 PM, Shoeb Bhinderwala
<[email protected]> wrote:
> I wrote the following function to create a SQL IN clause from a list
> of values. Essentially the function creates a single string which is a
> comma separated quoted list of the values surrounded by parenthesis.
If you're using clojure.java.jdbc, you could generate a lit of ? for
the SQL and just using the vector directly... something like this (off
the top of my head, completely untested):
(def qs (clojure.string/join "," (repeat (count xs) "?")))
(def sql (str "select * from table where id in (" qs ")"))
(clojure.java.jdbc/with-query-result conn rows
[ sql xs ]
(do-something-to rows))
Sorry, don't have a REPL open right now to test this...
--
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/
World Singles, LLC. -- http://worldsingles.com/
Railo Technologies, Inc. -- http://www.getrailo.com/
"Perfection is the enemy of the good."
-- Gustave Flaubert, French realist novelist (1821-1880)
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
