Peter Fitzgibbons
2005-Mar-29 03:08 UTC
RE: [ActiveRecord] 1.9.0SqlServerAdapteradd_limit_with_offset! Not returning expected results
Currently running Rails 0.11.1 (which includes ActiveRecord 1.9.0) Here is gems list actionmailer (0.8.1) actionpack (1.7.0) actionwebservice (0.6.2) activerecord (1.9.1) activesupport (1.0.3) fxruby (1.2.2) rails (0.11.1) rake (0.5.0) RedCloth (3.0.3) sources (0.0.1) wee (0.7.0) As far as I can tell, the best solution on Sql Server for paged results is at best a limited solution. Is it possible to override the other methods in SqlServerAdapter to use a cached recordset instead? Peter J. Fitzgibbons Applications Manager Lakewood Homes - "The American Dream Builder"(r) Peter.Fitzgibbons-STCS76aLmhk1y/cD6r8xzl6hYfS7NtTn@public.gmane.org (847) 884-8800 ________________________________ From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of DeLynn Berry Sent: Monday, March 28, 2005 5:26 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: RE: [Rails] [ActiveRecord] 1.9.0SqlServerAdapteradd_limit_with_offset! Not returning expected results Peter, Have you upgraded to Rails 0.11.1? The SQL Server Adapter in 0.11.0 was not updated for the new add_limit_with_offset! method. Update to 0.11.1 and see if that doesn''t fix things for you. -- DeLynn Berry delynnb-+9FQAZFMD0vCste6SmUHRhL4W9x8LtSr@public.gmane.org -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Peter Fitzgibbons Sent: Monday, March 28, 2005 3:58 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: [Rails] [ActiveRecord] 1.9.0 SqlServerAdapteradd_limit_with_offset! Not returning expected results Hello, SqlServerAdapter is not returning the correct recordset with add_limit_with_offset!. The first record page is always returned. I tested this against MySql / MsSql2000 with identical schema and it is definitely a database issue. I am stuck with MsSQl so I need this to work. My testbed is the rails Todo demo. The offending call is produced by the ActionPack::Paginator. Thank you. Peter J. Fitzgibbons Applications Manager Lakewood Homes - "The American Dream Builder"(r) Peter.Fitzgibbons-STCS76aLmhk1y/cD6r8xzl6hYfS7NtTn@public.gmane.org (847) 884-8800 _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails