ReggieB's profile - sod

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.

There was a problem

You must be a member of this account.

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