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.
