Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

ReggieB's latest activity

Thursday, January 15 2009
260 incorrect set of records returned when using order on a field with little var... was updated in will_paginate library
  • ReggieB
    ReggieB commented at 6:05 PM

    That just says you need an ORDER BY clause, whereas in fact you need more than that - you need an ORDER BY clause that uniquely identifies and orders each recor...

  • ReggieB
    ReggieB commented at 4:04 PM

    My argument would be that it isn't the user who has chosen to flip the data back and forth. It is the way will_paginate processes the data that makes this an is...

Wednesday, January 14 2009
260 incorrect set of records returned when using order on a field with little var... was created in will_paginate library
  • ReggieB
    ReggieB created the ticket at 7:33 PM

    I think I have found a bug this time :o) . However, it may be a MS SQL only error as I haven't tested the problem with MySQL.

    I have a table of "support cases" ...

Wednesday, December 24 2008
257 order by not working with joined tables was updated in will_paginate library
  • ReggieB
    ReggieB commented at 12:23 PM

    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...

  • ReggieB
    ReggieB commented at 11:46 AM

    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...
Monday, December 22 2008
257 order by not working with joined tables was updated in will_paginate library
  • ReggieB
    ReggieB commented at 2:33 PM

    I've also tried using paginate_by_sql:

    
          sql = <<EOF
    SELECT [o].*,
      [c].[Comp_Name] AS company_name,
      [p].[Pers_Salutation] AS person_salutation,
     ...
  • ReggieB
    ReggieB commented at 2:29 PM

    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 ...
  • ReggieB
    ReggieB created the ticket at 2:24 PM

    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...