Re: Multiple table SELECT problem

[Stephen C. Gilardi]

On Jan 5, 2009, at 7:59 PM, ck wrote:

Ops, my mistake. Second one should be:

(defn db-read []
 (sql/with-connection db
   (sql/with-results res
    "SELECT
         users.id,
         users.name
     FROM
         users
     INNER JOIN
         roles
         ON
         user.id = roles.user_id
     ORDER BY
         users.id;"
    (doseq [rec res]
       (println rec)))))

Sorry about that,

What does "scrapbook/db-read" return when typed at the repl.

--Steve

In the "doesn't work" case, had you defined db-read in the "scrapbook" namespace?

smime.p7s
Description: S/MIME cryptographic signature