Documentation:
http://clojure.github.com/java.jdbc/doc/clojure/java/jdbc/UsingSQL.html
On Friday, January 6, 2012, jayvandal <s...@ida.net> 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, BOOK_PRICE, BOOK_AUTHOR)
> VALUES('%','joe','12', 'siley')"];
>
> (println rows))))
>
> user=> (mysql.core/add-ausers)
> java.sql.SQLException: Can not issue data manipulation statements with
> executeQu
> ery(). (NO_SOURCE_FILE:0)
>
> What is Query??
>
> On Jan 6, 1:20 pm, Allen Johnson <akjohnso...@gmail.com> wrote:
>> 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 <s...@ida.net> wrote:
>> > 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 []
>> > (sql/with-connection db
>> > ;(sql/with-query-results rows
>>
>> > sql ["INSERT INTO books(BOOK_ID, BOOK_NAME, BOOK_PRICE,
>> > BOOK_AUTHOR) VALUES('2','joe','12', 'siley')"]
>> > (println rows)
>>
>> > why or?
>> > ;)
>> > ))
>>
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups "Clojure" group.> To post to this group, send email
tocloj...@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 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
>
--
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/
World Singles, LLC. -- http://worldsingles.com/
"Perfection is the enemy of the good."
-- Gustave Flaubert, French realist novelist (1821-1880)
--
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
