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