am trying to get the index page going on my table I am using a table on Micrsoft SQL Server, when showing a single row from the table it works OK. but when accessing the index I am gettingthe following error message ActiveRecord::ActiveRecordError: Incorrect syntax near ''\.''.: SELECT * FROM (SELECT TOP 15 * FROM (SELECT TOP 15 sproclogs.* FROM sproclogs ORDER BY sproclogs.[id] ASC) AS tmp1 ORDER BY sproclogs\. \ [[id]\] DESC) AS tmp2 ORDER BY sproclogs\.\[[id]\] ASC The trace that I am getting is: :/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/connection_adapters/abstract_adapter.rb:188:in `log'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9/ lib/active_record/connection_adapters/jdbc_adapter.rb:581:in `execute'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9/ lib/active_record/connection_adapters/jdbc_adapter.rb:641:in `select'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9/ lib/active_record/connection_adapters/jdbc_adapter.rb:566:in `jdbc_select_all'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/base.rb:635:in `find_by_sql'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/base.rb:1490:in `find_every'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/base.rb:589:in `find'' vendor/plugins/active_scaffold/lib/active_scaffold/finder.rb:175:in `find_page'' vendor/plugins/active_scaffold/lib/paginator.rb:66:in `call'' vendor/plugins/active_scaffold/lib/paginator.rb:66:in `page'' vendor/plugins/active_scaffold/lib/paginator.rb:93:in `call'' vendor/plugins/active_scaffold/lib/paginator.rb:93:in `items'' vendor/plugins/active_scaffold/lib/active_scaffold/actions/list.rb: 66:in `do_list'' vendor/plugins/active_scaffold/lib/active_scaffold/actions/list.rb: 33:in `list'' vendor/plugins/active_scaffold/lib/active_scaffold/actions/list.rb: 8:in `index'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/base.rb:1253:in `perform_action'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/filters.rb:617:in `call_filters'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/filters.rb:610:in `perform_action_with_filters'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'' C:/jruby-1.1.6/lib/ruby/1.8/benchmark.rb:293:in `measure'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/rescue.rb:136:in `perform_action_with_rescue'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/caching/sql_cache.rb:13:in `perform_action_with_caching'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/ active_record/query_cache.rb:8:in `cache'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/caching/sql_cache.rb:12:in `perform_action_with_caching'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/base.rb:524:in `process'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/filters.rb:606:in `process_with_filters'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/session_management.rb:134:in `process_with_session_management_support'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/base.rb:392:in `process'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:183:in `handle_request'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:110:in `dispatch_unlocked'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:123:in `dispatch'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:122:in `dispatch'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:132:in `dispatch_cgi'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/ action_controller/dispatcher.rb:39:in `dispatch'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/ webrick_server.rb:103:in `handle_dispatch'' C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/ webrick_server.rb:74:in `service'' C:/jruby-1.1.6/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'' C:/jruby-1.1.6/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'' C:/jruby-1.1.6/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'' --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---