Can you post the SQL template (with ? symbols) you are trying to execute?
Usually, with PostgreSQL you can specify ?::integer in place of ? to imply
that the passed parameter is an integer.
Shantanu
On Tuesday, 11 February 2014 13:52:54 UTC+5:30, The Dude (Abides) wrote:
>
> Hi, I'm getting an error calling a record from an id passed via a url
> using Korma Sql. The error says:
>
> org.postgresql.util.PSQLException
> ERROR: operator does not exist: smallint = character varying Hint: No
> operator matches the given name and argument type(s). You might need to add
> explicit type casts. Position: 57
>
> I have a list of members, with a url /member/:id to call profile for that
> member in the view showing the member list. Here's my 3 moving parts:
>
> ROUTE
>
> (GET "/member/:id" [id] (get-the-member id))
>
> FUNCTION
>
> (defn get-the-member [id]
> (layout/render
> "member/profile.html"
> {:member (db/get-member-url id)}))
>
> MODEL
>
> (defn get-member-url [id]
> (first (select members
> (where {:id id})
> (limit 1))))
>
> Now if I hard code the id number in the model, it works, but its not
> accepting the id var as an integer. How would I give it an explicit
> typecast in this instance. Or would it perhaps be better to use java.jdbc
> or another ORM like Sql Lingov, HoneySQL, Clojureql or clojure-sql? Rest of
> crud working fine, but id var not being accepted by the model. The model
> itself works if an id number is hardcoded. Perhaps I'm missing some simple
> syntax point here?
>
--
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.
