Displaying 3 results from an estimated 3 matches for "expires_date".
Did you mean:
expire_date
2006 Jan 13
2
JOIN
Hi!
For the following example I want to retrieve the last 10 LastEntries for
experis_date >= now.
class User < ActiveRecord::Base
has_one :last_entries
def self.last_entry_items
find(:all,
# :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...
2004 Jan 12
2
LCR / Trollphone Rate Engine
...)
| extra | varchar(40) | YES | | NULL | | (Extra what?)
| prefix | varchar(10) | | MUL | | | (Ok, prefix of the number...)
| active_date | date | YES | | NULL | | (Starting date of rate)
| expires_date | date | YES | | NULL | | (Ending date of rate)
| firstperiod | int(10) unsigned | | | 0 | | (Explain?)
| periods | int(10) unsigned | | | 0 | | (Examples?)
| startcost | int(10) unsigned |...
2006 Feb 21
6
Select articles from group with id ''1'' and id ''2''
...user_id) references users(id),
primary key (id)
);
CREATE TABLE groups (
id int auto_increment,
name varchar(16) NOT NULL,
description varchar(32) NOT NULL,
constraint fk_items_users foreign key (user_id) references users(id),
primary key (id)
);
CREATE TABLE article_groups (
id int auto_increment,
expires_date datetime,
suspend datetime,
group_id int NOT NULL, # FOREIGN KEY groups.id,
article_id int NOT NULL, # FOREIGN KEY articles.id
constraint fk_items_groups foreign key (group_id) references
groups(id),
constraint fk_items_articles foreign key (article_id) references
article(id),
primary key (id)
);...