Re: clojure.contrib.sql and inner joins

2009-02-04 Thread Stephen C. Gilardi
On Feb 4, 2009, at 11:09 AM, BrianS wrote: Once I substituted actual column names in the SELECT portion of the statement, the inner joins started working as they should. Excellent! As always, thanks for the attention, assistance, and the original work in clojure.contrib.sql, it has all be

Re: clojure.contrib.sql and inner joins

2009-02-04 Thread BrianS
Steve, Big apologies, I should have done just a little more investigating before posting. I serve as my team's DBA, so I should rightfully abhor the "SELECT * ", but that is what was causing the problem:duplicate column names in the returnset, as you said above. Once I substituted actual colum

Re: clojure.contrib.sql and inner joins

2009-02-04 Thread Stephen C. Gilardi
On Feb 4, 2009, at 9:46 AM, Stephen C. Gilardi wrote: That sounds like what's going on in your example. Can you please confirm? Also, if you have one handy, could you please send me a short, standalone example of code that triggers the problem? I'd like to look at how clojure.contrib.sql

Re: clojure.contrib.sql and inner joins

2009-02-04 Thread Stephen C. Gilardi
Hi Brian, On Feb 4, 2009, at 9:21 AM, BrianS wrote: However, whenever I insert a SQL query that contains an inner join command (standard SQL), I get the following error: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Too many arguments to struct cons

clojure.contrib.sql and inner joins

2009-02-04 Thread BrianS
This may be a duplicate post, if so I apologize. I am having a problem while investigating the inner workings and capabilities of the clojure.contrib.sql class, specifically with the "inner join" syntax. I have a function that returns recordset maps that is taken directly from the test.clj file in