hey, i want a list of callers, 10 per page, depending on which firm id
(in table
geotags)
@callerid_pages, @callerids = paginate :caller_ids, :conditions =>
[“caller_ids.geotag_id = geotags.id and geotags.firm_id = ?” , firm_id],
:order_by => “geotags.address1 ASC” , :include=>[:geotag], :per_page =>
10
and i get this error
#42S02Unknown table ‘geotags’ in where clause: SELECT COUNT(*) FROM
caller_ids
WHERE (caller_ids.geotag_id = geotags.id and geotags.firm_id = 1)
thanks