Hi
You're not supposed to specify the insert statement. Try this:
(sql/insert-record :books
{:BOOK_ID "%", :BOOK_NAME "joe", :BOOK_PRICE 12, :BOOK_AUTHOR "siley"})
...using the same values as in your insert statement. Don't know about
BOOK_ID, though...
--
Henrik
On Fri, Jan 6, 2012 at 10
Documentation:
http://clojure.github.com/java.jdbc/doc/clojure/java/jdbc/UsingSQL.html
On Friday, January 6, 2012, jayvandal wrote:
> I tried this code :
> (defn add-ausers [user]
> (sql/with-connection db
> (sql/insert-record :books user
> ["INSERT INTO books(BOOK_ID, BOOK_NAME, BO
i am using leinningen and mysql example. I can select records as:
(defn list-ausers []
(sql/with-connection db
(sql/with-query-results rows
["SELECT * FROM books WHERE BOOK_ID = '1'"]
(println rows
but I can't insert records,i doesn't like the query as:
(defn add-ausers [
I tried this code :
(defn add-ausers [user]
(sql/with-connection db
(sql/insert-record :books user
["INSERT INTO books(BOOK_ID, BOOK_NAME, BOOK_PRICE, BOOK_AUTHOR)
VALUES('%','joe','12', 'siley')"];
(println rows
user=> (mysql.core/add-ausers)
java.sql.SQLException: Can
You'd want to use one of the insert functions for that:
(defn add-user [user]
(sql/with-connection db
(sql/insert-record :books user)))
http://clojure.github.com/java.jdbc
Allen
On Fri, Jan 6, 2012 at 3:13 PM, jayvandal wrote:
> i am using leinningen and mysql example. I can select reco
i am using leinningen and mysql example. I can select records as:
(defn list-ausers []
(sql/with-connection db
(sql/with-query-results rows
["SELECT * FROM books WHERE BOOK_ID = '1'"]
(println rows
but I can't insert records,i doesn't like the query as:
(defn add-ausers [