Displaying 3 results from an estimated 3 matches for "42s02unknown".
Did you mean:
42000unknown
2006 Jan 13
2
JOIN
...# :include => "last_entries",
# :conditions => "last_entries.expires_date >= now()",
:order => "id desc",
:limit => 10)
end
end
class LastEntrie < ActiveRecord::Base
belongs_to :user
end
Rails tells me the following:
Mysql::Error: #42S02Unknown table ''last_entries'' in where clause: SELECT * FROM
users WHERE (last_entries.expires_date >= now()) ORDER BY id desc LIMIT 10
I was expecting to see here an inner join or something. Then I tried using
:include and rails gave the following error:
uninitialized constant Last...
2005 Dec 12
2
count sql failing with unknown table....
Hey Rails People,
I''m doing my first Rails app and I''m having a newbie problem with the
count method....
Mysql::Error: #42S02Unknown table ''jobs_sectors'' in where clause: SELECT
COUNT(*) FROM jobs WHERE (jobs_sectors.sector_id = 1 )
Extracted source (around line #4):
1: <div class="sectors">
2: <ul>
3: <% for sector in @sectors -%>
4: <li><%= sector.name %> ( <...
2005 Dec 23
1
pagination problem
hey,
i have this problem
in the database i have 32 records
and the sql filtered 4 records
#getting the callerid records depending on the given paramaters and paginate it
@callerid_pages = Paginator.new self, CallerId.count, 10, @params[''page'']
@caller_ids = CallerId.find(:all, :conditions =>["geotags.firm_id = ? ",
@firm_id], :order => " geotags.address1