Displaying 2 results from an estimated 2 matches for "articlegroup".
2006 Jan 30
3
Howto change @article.article.headline to @article.headline ?
I have to actions:
def index
@articles = Article.find(:all,
:conditions => "un_published != ''1''",
:order => "created_on desc")
end
and
def group
id = params[:id]
@articles = ArticleGroup.find(:all,
:include => [:group, :article],
:conditions => ["articles.un_published != ''1'' and groups.id =
?", id],
:order => "articles.created_on desc")
render :action => ''index''
end
The las...
2006 Feb 21
6
Select articles from group with id ''1'' and id ''2''
I have to tables: "articles" and "groups". Between I have
article_groups as a jointable. Now I want to select every article who
is a member of group with id ''1'' and id ''2''. Whats best way to get
that?
Extract from schemas:
CREATE TABLE articles (
id int auto_increment,
ingress text NOT NULL,
story_text longtext,
constraint fk_items_users