Sod will_paginate library

Comments and changes to this ticket

• 

  Mislav February 11th, 2009 @ 07:23 PM

  I don't think there is a bug - both find and count use the built-in ActiveRecord methods.

  You haven't given me enough information. First tell me the will_paginate version, then Rails version, then paste the code that performs this paginating find and count.

• You flagged this item as spam.
  

  friofool February 11th, 2009 @ 09:22 PM

  will_paginate : mislav-will_paginate-2.3.6

  rails : 2.2.2

  and my request :

  conditions = "inner join mod_icom_prods as mip on (mifo.mod_icom_prod_id = mip.id)"

  conditions += " inner join mod_icom_marque_prods as mimp on (mip.id = mimp.mod_icom_prod_id)"

  conditions += "where mip.visibilite_prod = 1 AND mip.statut_promo ='destockage' and mifo.valide = 1 and mip.visibilite_prod = 1 and mimp.mod_icom_marque_id = 45"

  ModIcomFilesOption.paginate(:all,

                          :select => "mifo.id,mifo.filename,mifo.mod_icom_option_id,mifo.mod_icom_prod_id",
                                    :joins => "as mifo " + conditions,
                                    :per_page  =>  9,
                                    :page => params[:page],
                                    :group => "mifo.mod_icom_option_id,mip.id",
                                    :order => " mimp.position_prod asc"
                                    )
  
  

  for the count method i tried to put a logger in wp_count method on the finder module :

  .... logger.info("-----" + count.length.to_s) count.respond_to?(:length) ? count.length : count end

  thanks for your help

• You flagged this item as spam.
  

  friofool February 12th, 2009 @ 09:43 AM

  i use the solution in this post :

  http://groups.google.com/group/w...

  count results are wrong when a "group by" clause appear in the query.

  sorry for the inconvenience