DeLynn Berry
2005-Mar-28 23:25 UTC
RE: [ActiveRecord] 1.9.0 SqlServerAdapteradd_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