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/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
as for forum software: http://rforum.andreas-s.net/ your idea with dates should work, too. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
And http://github.com/radar/rboard - Fully supports Rails 2.2 and internationalisation. ----- Ryan Bigg Freelancer http://frozenplague.net On 14/01/2009, at 11:04 PM, 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 > -- > Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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, mmartino-Qg9A6ZDDoxJU2t5yBuglSNBPR1lH4CV8@public.gmane.org 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-- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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...-Qg9A6ZDDoxJU2t5yBuglSNBPR1lH4CV8@public.gmane.org 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 > > -- > Posted viahttp://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---