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 wrote:
>
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
... in ? is not supported in c.j.jdbc
On Tue, Dec 4, 2012 at 6:16 AM, Amir Wasim 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] {"status"
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 a