I think you can just insert the .find(:all, ...) before .status_is_not in your big long finder.
Rails 2.3 has some limitations on that sort of thing, but I think you're still fine. Bryan On Wed, Oct 10, 2012 at 12:12 PM, tomkins <[email protected]> wrote: > No errors now, but how do I apply it to the table? I have: self.this = > Engineer.find(:all, :conditions => ["available < ?", Date.today]) > hobo_index Engineer.status_is_not("left").apply_scopes(:search => > [params[:search],:name, :description, :note], > :order_by => parse_sort_param(:name, > :base, :available, :bu, :possible_extension), > :base_is => params[:location], > :bu_is => params[:bu]),:per_page => > params[:records], :paginate => true > > On Wednesday, October 10, 2012 5:05:31 PM UTC+1, Bryan Larsen wrote: >> >> Yup, that's Rails 3 syntax. >> >> try Engineer.find(:all, :conditions => ["available_date < ?", Date.today]) >> >> Bryan >> >> On Wed, Oct 10, 2012 at 12:00 PM, tomkins <[email protected]> wrote: >> > My app is using rails 2.3.5, is this the problem? >> > >> > >> > On Wednesday, October 10, 2012 4:52:16 PM UTC+1, tomkins wrote: >> >> >> >> Yes, my model is called Engineer >> >> (class Engineer < ActiveRecord::Base) >> >> >> >> On Wednesday, October 10, 2012 4:47:32 PM UTC+1, Bryan Larsen wrote: >> >>> >> >>> Do you have an Engineer class derived from ActiveRecord::Base? I >> >>> assumed that was the name of your class based on your example sql. >> >>> If not, use your class name instead of Engineer. >> >>> >> >>> Bryan >> >>> >> >>> >> >>> On Wed, Oct 10, 2012 at 11:43 AM, tomkins <[email protected]> wrote: >> >>> > For me that returns: NoMethodError (undefined method `where' >> >>> > >> >>> > >> >>> > On Wednesday, October 10, 2012 4:36:44 PM UTC+1, Bryan Larsen wrote: >> >>> >> >> >>> >> def index >> >>> >> self.this = Engineer.where(["available_date < ?", Date.today]) >> >>> >> hobo_index >> >>> >> end >> >>> >> >> >>> >> Bryan >> >>> >> >> >>> >> >> >>> >> On Wed, Oct 10, 2012 at 11:26 AM, tomkins <[email protected]> wrote: >> >>> >> > I would like to know how I can do a conditional query: (SELECT * >> >>> >> > FROM >> >>> >> > engineers WHERE available_date < todaysDate) and then put the >> >>> >> > results >> >>> >> > inside >> >>> >> > a table plus. I currently can only get every engineer. >> >>> >> > Any help is greatly appreciated, thanks. >> >>> >> > >> >>> >> > -- >> >>> >> > You received this message because you are subscribed to the >> >>> >> > Google >> >>> >> > Groups >> >>> >> > "Hobo Users" group. >> >>> >> > To view this discussion on the web visit >> >>> >> > https://groups.google.com/d/msg/hobousers/-/lYhsGBQ8yjgJ. >> >>> >> > To post to this group, send email to [email protected]. >> >>> >> > To unsubscribe from this group, send email to >> >>> >> > [email protected]. >> >>> >> > For more options, visit this group at >> >>> >> > http://groups.google.com/group/hobousers?hl=en. >> >>> > >> >>> > -- >> >>> > You received this message because you are subscribed to the Google >> >>> > Groups >> >>> > "Hobo Users" group. >> >>> > To view this discussion on the web visit >> >>> > https://groups.google.com/d/msg/hobousers/-/1-M_lgTzRtwJ. >> >>> > >> >>> > To post to this group, send email to [email protected]. >> >>> > To unsubscribe from this group, send email to >> >>> > [email protected]. >> >>> > For more options, visit this group at >> >>> > http://groups.google.com/group/hobousers?hl=en. >> > >> > -- >> > You received this message because you are subscribed to the Google >> > Groups >> > "Hobo Users" group. >> > To view this discussion on the web visit >> > https://groups.google.com/d/msg/hobousers/-/a4AqZL-dcS4J. >> > >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > For more options, visit this group at >> > http://groups.google.com/group/hobousers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Hobo Users" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/hobousers/-/xWzV4c4InpYJ. > > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/hobousers?hl=en. -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
