Thanks both.
On 9 July 2013 01:55, James Ferguson <jferguson2....@gmail.com> wrote:
>
>
> On Monday, July 8, 2013 5:28:07 PM UTC-4, Colin Yates wrote:
>>
>> Using the latest release of java.jdbc, does anybody know how I can
>> construct a where clause when I want to check if the value is one of many
>> values?
>>
>> For example, if I have a filter {:age [1 2 3 4]} then (sql/where filter)
>> causes an error: "Wrong data type: java.lang.**NumberFormatException:
>> For input string: "[1 2 3 4]".
>>
>> Any idea how to do this in clojure.java.jdbc?
>>
>
> I've been using http://sqlkorma.com/ for CRUD. A query with your filter
> would be
>
> (select tablename
> (where {:age [in [1 2 3 4]]}))
>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "Clojure" group.
> To post to this group, send email to clojure@googlegroups.com
> Note that posts from new members are moderated - please be patient with
> your first post.
> To unsubscribe from this group, send email to
> clojure+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/clojure?hl=en
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "Clojure" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/clojure/7A_HAAISvEk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> clojure+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
