diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-01 17:20:04 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-01 17:20:04 +0000 |
commit | f2a29ca43cb0de38a25bf7f68bca5c11871692ce (patch) | |
tree | 49fafc3247a77dc1b8797e4425b28923af6a51d0 /activerecord/lib/active_record/connection_adapters/mysql_adapter.rb | |
parent | 64612db7cf85aee8434e7b9b4fd8d6d0249c60e4 (diff) | |
download | rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.tar.gz rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.tar.bz2 rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.zip |
Added support for ODBC connections to MS SQL Server so you can connect from a non-Windows machine #1569 [Mark Imbriaco/DeLynn Berry] Added support for limit/offset with the MS SQL Server driver so that pagination will now work #1569 [DeLynn Berry]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1583 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/lib/active_record/connection_adapters/mysql_adapter.rb')
-rwxr-xr-x | activerecord/lib/active_record/connection_adapters/mysql_adapter.rb | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb b/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb index 89633639d3..c11ce3772a 100755 --- a/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb @@ -172,11 +172,17 @@ module ActiveRecord structure += select_one("SHOW CREATE TABLE #{table.to_a.first.last}")["Create Table"] + ";\n\n" end end - - def add_limit_with_offset!(sql, limit, offset) - sql << " LIMIT #{offset}, #{limit}" + + def add_limit_offset!(sql, options) + return if options[:limit].nil? + + if options[:offset].blank? + sql << " LIMIT #{options[:limit]}" + else + sql << " LIMIT #{options[:offset]}, #{options[:limit]}" + end end - + def recreate_database(name) drop_database(name) create_database(name) |