Ruby on Rails Dates

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?

Also, are there any forum systems built with Ruby on Rails that I can
download for use on my site?

Thanks in advance, Rob

as for forum software:
http://rforum.andreas-s.net/

your idea with dates should work, too.

On Jan 14, 2009, at 7:34 AM, Rob Pa wrote:

: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.

LMGTFY - Let Me Google That For You

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

And GitHub - radar/rboard: A fully featured forum system compatible with Rails 2.3 - Fully supports Rails 2.2 and
internationalisation.

Ryan B.
Freelancer

I don’t mean to be too intrusive as I am a dreadful IT Recruiter that
you probably all despise. I am working on filling a number of RoR
Developer positions for an exciting young company in NYC. If you are
interested in learning more about the position please e-mail me,
[email protected] or call me at 212.991.1835. No one has to
know that you contacted me regarding and you can still bash me here in
the blog.

Have a great day! Thanks!

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?

Also, are there any forum systems built with Ruby on Rails that I can
download for use on my site?

Thanks in advance, Rob

Can’t you just send out an email, with [JOBS] in the subject? I don’t
think anyone would be bothered by that. Don’t change a discussion
subjects just for spite. Have some class.

On Jan 14, 11:13 am, Michael Michael <rails-mailing-l…@andreas-