Hi There, I am running an app with an AS400 for the database. in the development environment I am getting the following error: 37000 (-104) [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token ` was not valid. Valid tokens: ( TABLE LATERAL <IDENTIFIER>. /usr/local/ruby/lib/ruby/gems/1.9.1/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:1519:in `rescue in select' /usr/local/ruby/lib/ruby/gems/1.9.1/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:1514:in `select' /usr/local/ruby/lib/ruby/gems/1.9.1/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:770:in `select_all' /usr/local/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.10/lib/active_record/base.rb:665:in `find_by_sql' /var/www/onlineordering.coastalpet.com/app/models/item.rb:183:in `filter_categories' /var/www/onlineordering.coastalpet.com/app/controllers/products_controller.rb:6:in `index' here is the revelvant code for that above two pages: /var/www/onlineordering.coastalpet.com/app/models/item.rb:183:in `filter_categories' s = Item.find_by_sql [sql, upc_rule, query_account_number, upc_rule, query_account_number, upc_rule, query_account_number, upc_rule, query_account_number, upc_rule, query_account_number, upc_rule, query_account_number, upc_rule, query_account_number] /var/www/onlineordering.coastalpet.com/app/controllers/products_controller.rb:6:in `index' = @categories = Item.filter_categories(session[:upc_rule], session[:query_account_number]) I am looking for thoughts on the error Token ` was not valid. Valid tokens: ( TABLE LATERAL <IDENTIFIER>. as I am not familiar with this error. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/d1f4fb8140a58aed6c668a166c39b719%40ruby-forum.com. For more options, visit https://groups.google.com/d/optout.