search for: merch_item_id

Displaying 1 result from an estimated 1 matches for "merch_item_id".

2005 Dec 10
0
Paginate - Count(*) Broken or Am I Cheating?
I have the following paginator setup: @merch_pages, @merch = paginate :merch_item, :per_page => 15, :select => ''DISTINCT mi.id, mi.merch_image, mi.created_at, mi.artist_id, mi.item_description, art.sort_name'', :join => ''as mi JOIN merch_formats mf ON mi.id = mf.merch_item_id JOIN artists art ON mi.artist_id = art.id'', :order => ''art.sort_name'', :conditions => ["mf.active_status = 1 AND format_name = ? AND format_name <> ''Poster''", params[:id]] This part works like a charm... Problem is that the COUNT(*...