Ruby on Rails Dates

[Rob Pa]

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
--
Posted via http://www.ruby-forum.com/.

[MaD]

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

your idea with dates should work, too.

[Rob Biedenharn]

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

[Ryan Bigg]

And http://github.com/radar/rboard - Fully supports Rails 2.2 and
internationalisation.
-----
Ryan Bigg
Freelancer
http://frozenplague.net

[Michael Michael]

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,
mmar...@apexsystemsinc.com 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!

[Harold]

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-

s.net> wrote:
> 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,

> mmart...@apexsystemsinc.com or call me at 212.991.1835. No one has to