search for: add_limit_offset

.../usr/lib/site_ruby/1.8/DBD/ODBC/ODBC.rb:168:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:640:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:671:in `select_all'' /vendor/rails/activerecord/lib/active_record/connection_adapters/ sqlserver_adapter.rb:354:in `add_limit_offset!'' /vendor/rails/activerecord/lib/active_record/base.rb:931:in `add_limit!'' /vendor/rails/activerecord/lib/active_record/base.rb:924:in `construct_finder_sql'' /vendor/rails/activerecord/lib/active_record/base.rb:395:in `find'' /vendor/rails/...

...vision 4185. 1) Error: test_should_limit_calculation(CalculationsTest): TypeError: can''t convert String into Array ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in `replace'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in `add_limit_offset!'' ./test/../lib/active_record/base.rb:1046:in `add_limit!'' ./test/../lib/active_record/calculations.rb:156:in `construct_calculation_sql'' ./test/../lib/active_record/calculations.rb:172:in `execute_grouped_calculation'' ./test/../lib/active_r...

So I''m trying to do a find with an order by specific column values thing, but some of the columns are attributes through associations. So I did some eager loading with the :include option to try and access the attributes of the object I''m doing the find on. Stuff has been blowing up on me so far. Here''s the code in the controller right now: sort_by = params[:sort_by]

.../usr/lib/site_ruby/1.8/DBD/ODBC/ODBC.rb:168:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:640:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:671:in `select_all'' /vendor/rails/activerecord/lib/active_record/connection_adapters/ sqlserver_adapter.rb:354:in `add_limit_offset!'' /vendor/rails/activerecord/lib/active_record/base.rb:931:in `add_limit!'' /vendor/rails/activerecord/lib/active_record/base.rb:924:in `construct_finder_sql'' Any help appreciated! Jamie ------ class ActionController::Base def paginate_with_sort(colle...

hi! after wondering why i can''t find alot of records i eventually found the problem in the sqlserver_adapters implementation of "add_limit_offset!". the problem is when using MSSQL with the sqlserver_adapter paging will only work when at least one column is defined in ":order". for example i was indexing a table with 2912 records, the generated sql for the batches were these: SELECT * FROM (SELECT TOP 1000 * FROM (SELECT TO...

Skipped content of type multipart/alternative-------------- next part -------------- Index: connection_adapters/abstract/connection_specification.rb =================================================================== --- connection_adapters/abstract/connection_specification.rb (revision 4617) +++ connection_adapters/abstract/connection_specification.rb (working copy) @@ -1,10 +1,21 @@ require

It would be very helpful if the core team could define and document the expected behavior of DatabaseStatements.execute(). The implementations appear to vary. Most adapters will return some sort of native result set, SQL Server returns nil and expects a block, DB2 and Sybase return the affected row count. So please, will someone in core explain the expected behavior and can the execute()

Hello, Is there any function which will parse different sql options and add them to a sql query? I found this `add_limit_offset!'' function, but it is an instance method and I am not able to use it as a class method. Is there any workaround which will let me use it a class method, or is there some other alternate function? Thanks. -- Surendra Singhi http://ssinghi.kreeti.com, http://www.kreeti.com Read my blog at:...