On Jan 14, 2009, at 7:34 AM, Rob Pa wrote: > Hi, > > I am using a MySQL database and have a row callsed date in my fixtures > table. I am wanting to display fixtures coming up, i.e. ahead of > todays > date. > > In my controller I am thinking of doing; > @fixtures = Fixtures.find(:all, :conditions => "date > #{Date.today} > ", > :order => "id DESC") > > Do dates work this way, is this the correct way to go about it?
At least, I'd change this to: @fixtures = Fixture.find(:all, :conditions => ['data > ?', Date.today], :order => 'id DESC') But it would be better to put this into a named scope: class Fixture named_scope :future, lambda { {:conditions => ['data > ?', Date.today]} } end then, in your controller @fixtures = Fixture.future > Also, are there any forum systems built with Ruby on Rails that I can > download for use on my site? > > Thanks in advance, Rob > -- I was about to give you a couple answers, but then I re-read your question. I'm not sure about forums, but there are certainly a few options for wikis. http://letmegooglethatforyou.com/?q=ruby+rails+forum+software -Rob Rob Biedenharn http://agileconsultingllc.com r...@agileconsultingllc.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---