Hi I have the find statement below, how can I apply another condition to this to say AND status > 3 @projectReport = Project.find(:all, :conditions => ''status != 7'') Thanks scott -- Posted via http://www.ruby-forum.com/.
On 6/5/06, scott <scott@boxuk.com> wrote:> Hi > > I have the find statement below, how can I apply another condition to > this to say AND status > 3 > > @projectReport = Project.find(:all, :conditions => ''status != 7'') > > Thanks > scott > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >:conditions just throws in a WHERE clause. @projectReport = Project.find(:all, :conditions => ''status != 7 AND status > 3'')
@projectReport = Project.find(:all, :conditions => ''status != 7 AND active = 1'') scott wrote:> Hi > > I have the find statement below, how can I apply another condition to > this to say AND status > 3 > > @projectReport = Project.find(:all, :conditions => ''status != 7'') > > Thanks > scott-- Posted via http://www.ruby-forum.com/.
Sorry, I didn''t see the specific thing you wanted to do @projectReport = Project.find(:all, :conditions => ''status != 7 AND status > 3'') ryan wrote:> @projectReport = Project.find(:all, :conditions => ''status != 7 AND > active = 1'') > > scott wrote: >> Hi >> >> I have the find statement below, how can I apply another condition to >> this to say AND status > 3 >> >> @projectReport = Project.find(:all, :conditions => ''status != 7'') >> >> Thanks >> scott-- Posted via http://www.ruby-forum.com/.
On Jun 5, 2006, at 9:10 AM, scott wrote:> I have the find statement below, how can I apply another condition to > this to say AND status > 3 > > @projectReport = Project.find(:all, :conditions => ''status != 7'')@projectReport = Project.find(:all, :conditions => ''status != 7 and status > 3'') :-) -- -- Tom Mornini