aha, thanks Sean
I tried alternate and did the following
= (sql/with-connection (db-connection)
(sql/do-commands (str update TASK_T_MSGIDS set status='T' where
msg_id in ( (apply str (interpose \, acks)) ) ))
)
= (sql/with-connection (db-connection)
(transaction
do-commands is intended for DDL, not SQL.
You just want do-prepared:
(sql/with-connection (db-connection)
(sql/do-prepared (str update TASK_T_MSGIDS set status='T' where
msg_id in ( (apply str (interpose \, acks)) ) ))
)
On Wed, Dec 5, 2012 at 1:13 AM, Amir Wasim
I am trying to use the following
(defn commit-acknowledged
[acks]
(sql/with-connection (db-connection)
(sql/transaction
(sql/update-values MSGIDS [msg_id in ? acks] {status H})
)
)
)
here acks is type of clojure.lang.PersistentVector when i call this
function i am
... in ? is not supported in c.j.jdbc
On Tue, Dec 4, 2012 at 6:16 AM, Amir Wasim amir.wa...@gmail.com wrote:
I am trying to use the following
(defn commit-acknowledged
[acks]
(sql/with-connection (db-connection)
(sql/transaction
(sql/update-values MSGIDS [msg_id in ? acks]