Re: how to use clojure.java.jdbc.sql

2013-09-09 Thread Abraham
Thanks On Monday, September 9, 2013 12:10:13 PM UTC+5:30, Sean Corfield wrote: > > The basic DSL cannot do 'like' so you probably want to look at > HoneySQL which is the recommended way to extend clojure.java.jdbc. > > > On Sun, Sep 8, 2013 at 11:07 PM, Abraham > > wrote: > > > > I want to ge

Re: how to use clojure.java.jdbc.sql

2013-09-08 Thread Sean Corfield
The basic DSL cannot do 'like' so you probably want to look at HoneySQL which is the recommended way to extend clojure.java.jdbc. On Sun, Sep 8, 2013 at 11:07 PM, Abraham wrote: > > I want to generate sql string using clojure.java.jdbc.sql for eg. > > "SELECT B.ID , B.TITLE ,B.AUTHOR , C.CA

how to use clojure.java.jdbc.sql

2013-09-08 Thread Abraham
I want to generate sql string using clojure.java.jdbc.sql for eg. "SELECT B.ID , B.TITLE ,B.AUTHOR , C.CATEGORY , S.STATUS FROM BOOK B ,CATEGORY C , STATUS S WHERE (B.CATEGORY_ID=C.ID) AND (B.STATUS_ID = B.ID) AND (B.TITLE LIKE "%TOM%")" How to do this usi