No worries :) Thanks anyway for good intentions. Closing

Damm, I just saw that the change has already been committed. I did do a search on "concat" before entering the ticket. Honest!

Working in mislav-will_paginate 2.3.6 and Rails 2.2.2 when calling paginated_section you'll get an error on line 145 with a deprecation warning. This;-

def pag...

Working on the problem further, its the square brackets causing the problem. They are commonly used in MS SQL code, but ActiveRecord seems to behave differently...

I've investigated this further and it is not a will_paginate bug. It's an active record bug. The same thing happens with a find :

class Opportunity
  def se...

I've also tried using paginate_by_sql:

      sql = <<EOF
SELECT [o].*,
  [c].[Comp_Name] AS company_name,
  [p].[Pers_Salutation] AS person_salutation,
 ...

Sorry - didn't get the format syntax right.

My problem is that:

ORDER BY c.comp_name

becomes

ORDER BY c\.comp_name

My code is

      @opportunities ...

I'm currently using Rails 2.1 and was using will_paginate 2.2.2. I've upgraded to mislav-will_paginate 2.3.6, but the problem persists. MS SQL 2005 database.

Th...

(from [f2031833b42eaaa10a92b551846e3d4e94fb486a]) use string key for 'page' parameter when constructing URLs in Merb [phatmann] [#256 state:resolved] http://gi...

This is for the latest version of the agnostic branch.

In merb 1.0.6.1, the page links are not being formed correctly after browsing to page 2, 3, etc. The links end up with double page params:

/foo?page=2&page=5

Th...

see also http://rails.lighthouseapp.com/p...

No prob ;)

That worked like a charm. All I did was use

Model.paginate :page => 1, :per_page => 10, :group => 'foo.id', :count => {:group => nil, :select => "DISTINCT fo...

That's rather unfortunate.

Does this help?

Model.paginate :page => 1, :per_page => 10,
  :group => 'foo', :count => { :group => nil }

That will cause the ...

Heh. Strictly speaking the boss is wary of production table /column names leaking out, and it looks like my attempt to sanitize our data didn't work so well. So...

In the latest application I'm developing, we're really putting named scopes to the max and so far I haven't seen a single MySQL query generated incorrectly.

So,...

In finder.rb, wp_count() passes off to count() in order to figure out how many total results exist. When :group is specified, count() uses execute_grouped_calcu...

This is because of a bug in ActiveRecord with Ruby 1.8.7.

I've investigated and it looks like ruby 1.8.7 + ActiveRecord 2.1.1 = FAIL

It's been fixed in Rails co...

Hey, I'm having the same problem, with the following model:

class Playlist < ActiveRecord::Base has_and_belongs_to_many :songs end

When I call @songs = Playlist...

Using activerecord-sqlserver-adapter (1.0.0) and Rails 2.2.2. Set up some nice named scopes to do things like filter by user_id and status, and then chained the...

Good point. Thanks

visible_page_numbers will take a very long time if the number of pages you have is large, say if you are returning web search results that have millions of page...

In my model only some relationships use finder_sql so I modified a bit your solution to make possible to chose which finder should be used and to make it access...

There is mention of SVN in your error messages. That's pretty weird, because will_paginate is entirely hosted in a git repository.

This is not a will_paginate b...

Encounter the following issue during installation of will_paginate:

When trying to run the command:

git merge braid/track

in the dos prompt, it throw the fol...

Oh, I missed that you said "activate your gems" instead of "require". All is well ;)

Thanks for the prompt response.

Not sure about the "enable" comment, though.

We only activate the gems in preinitializer, which means calling the rubygems 'gem'...

Your last point is valid. The gem dependency only caused problems. Although you shouldn't load will_paginate before Rails! Then you need an extra WillPaginate::...

I see this ticket:

http://sod.lighthouseapp.com/pro...

And this commit:

http://github.com/mislav/will_pa...

I'm wondering if we can remove it safely now, beca...

You are totally right. I just checked the table and one track had a dj_set NULL. This is my fault and I apologize for blaming the plugin. Thanks for pointing th...

How are you sure the plugin is causing this? From what I see from your code and error, the problem isn't in pagination at all, but in the fact that one of the T...

Hello, I have been trying to debug this issue and then i realized that plugin was causing this.

I am using the example of search from railscasts but I have a de...

I added a config option to allow turning the prev/next links on and off based on whether they would go anywhere or not. Changeset...

http://github.com/mjankows...

I've given this a lot of thought and resolved not to support list mode in core. I just don't see the semantic advantage, particularly when considering an unorde...