On Nov 18, 8:05 pm, Jeremy Evans <[email protected]> wrote: > On Nov 17, 8:17 am, Filipe A de Assis Moreira <[email protected]> > wrote: > > > > > > > > > > > Hi, > > > First of all thank you very much for the wonderful and well designed > > ORM library you guys have built. I'm building an sinatra app using > > Jruby(1.5.5), DataMapper (1.0.2) and querying a legacy database (SQL > > Server 2000). > > > The problem I'm having is when I try to do a raw SQL query using: > > results = repository.adapter.select("SELECT TOP 10 DET_STOCK_CODE, > > SUM(DET_GROSS) FROM [Table name] GROUP BY DET_STOCK_CODE") > > > I get the following error: > > > interning empty string > > ArgumentError: interning empty string > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:270:in `select_fields' > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:270:in `map' > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:270:in `select_fields' > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:39:in `select' > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:260:in `with_connection' > > from /home/guto/.rvm/gems/jruby-1....@report-sinatra/gems/dm-do- > > adapter-1.0.2/lib/dm-do-adapter/adapter.rb:33:in `select' > > from (irb):4 > > > Anyone has any ideas of what maybe happening? > > You probably need to alias the SUM call: > > results = repository.adapter.select("SELECT TOP 10 DET_STOCK_CODE, > SUM(DET_GROSS) AS SUM FROM [Table name] GROUP BY DET_STOCK_CODE") > > One could argue that DataMapper should check whether the string is > empty before attempting to intern it, as Sequel does. > > Jeremy
Hi Jeremy, Thank you very much for that. -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/datamapper?hl=en.
