Luca Roma wrote:> I have wrote this:
> EventDate.find(:all,
> :include => [:container,{:event =>
> [:photo,:event_type_names]},{:place=>:location}],
> :joins =>" RIGHT JOIN (SELECT
> event_dates.id,date_add(event_dates.date, INTERVAL i DAY ) AS date
> FROM (select 0 as i union all select 0 union all select 1
> union all select 2) as integers CROSS JOIN event_dates
> WHERE i<= number_days AND
(event_dates.days_of_week=''8''
> OR
concat(''%'',event_dates.days_of_week,''%'')
like
> concat(''%'',DATE_FORMAT(date_add( event_dates.date,
INTERVAL i DAY
> ),''%w''),''%''))
> ORDER BY date LIMIT 0,40) as date_days ON date_days.id=event_dates.id
> ",
> :order=>"date_days.date"
>
> I want select also the date_days.date attribute.
> Is there any mode to do it?
All the date_days fields will be selected by default,
the "date" field being available in each result as
event_date[:date].
You''re in trouble if this conflicts with an EventDate
attribute, because Active Records has ignored the
find :select option when eager loading is used (though
I''m not sure whether this is still the case for Rails 2.2).
A patch is available for Rails 2.0.2 that allows :select
to be used in these circumstances.
Are you sure you want to use a right join? This could
give Active Record trouble.
--
Rails Wheels - Find Plugins, List & Sell Plugins - http://railswheels.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
-~----------~----~----~----~------~----~------~--~---