From 4cd9c9561adcbb8f3267003bd3b01931e457ed6a Mon Sep 17 00:00:00 2001 From: David Heinemeier Hansson Date: Tue, 28 Dec 2004 16:26:06 +0000 Subject: Added the possibility for adapters to overwrite add_limit! to implement a different limiting scheme than "LIMIT X" used by MySQL, PostgreSQL, and SQLite. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@269 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/lib/active_record/base.rb | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'activerecord/lib/active_record/base.rb') diff --git a/activerecord/lib/active_record/base.rb b/activerecord/lib/active_record/base.rb index 8a0fab2252..ce10f03789 100755 --- a/activerecord/lib/active_record/base.rb +++ b/activerecord/lib/active_record/base.rb @@ -288,8 +288,9 @@ module ActiveRecord #:nodoc: sql << "#{joins} " if joins add_conditions!(sql, conditions) sql << "ORDER BY #{orderings} " unless orderings.nil? - sql << "LIMIT #{sanitize_conditions(limit)} " unless limit.nil? - + + connection.add_limit!(sql, sanitize_conditions(limit)) unless limit.nil? + find_by_sql(sql) end @@ -310,7 +311,8 @@ module ActiveRecord #:nodoc: sql = "SELECT * FROM #{table_name} " add_conditions!(sql, conditions) sql << "ORDER BY #{orderings} " unless orderings.nil? - sql << "LIMIT 1" + + connection.add_limit!(sql, 1) record = connection.select_one(sql, "#{name} Load First") instantiate(record) unless record.nil? -- cgit v1.2.3