On 15 March 2013 16:41, tamouse mailing lists <tamouse.li...@gmail.com>wrote:
> On Thu, Mar 14, 2013 at 5:16 AM, Sumit Srivastava
> <sumit.theinvinci...@gmail.com> wrote:
> > Also I did try it this way,
> >
> > arel = OfferOrder.includes(:a, :b).joins(:c).select('(CASE WHEN
> > ISNULL(c.fields2) THEN c.fields1 ELSE c.field2 END) ')
> >
> > Got error,
> >
> > ActiveModel::MissingAttributeError (missing attribute: a_id):
> >
> >
> >
> >
> > I did join on three tables.
> >>
> >> arel = OfferOrder.includes(:a, :b, :c) arel = arel.select('(CASE WHEN
> >> ISNULL(c.field2) THEN c.field1 ELSE c.field2 END) AS fraud')
> >>
> >> but when I run my code it gives error that
> >>
> >> (Mysql2::Error: You have an error in your SQL syntax; check the manual
> >> that corresponds to your MySQL server version for the right syntax to
> use
> >> near 'AS fraud)
> >
>
> What was the SQL it generated?
>
Resolved this. Had to defined the join conditions and it worked. Though am
stuck on another.
The select query is not working when another query is made using <<SQL tags
in the code. Can't avoid using those.
Regards
Sumit Srivastava
The power of imagination makes us infinite...
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/rubyonrails-talk/xH1LYbHTIIU/unsubscribe?hl=en-US
> .
> To unsubscribe from this group and all its topics, send an email to
> rubyonrails-talk+unsubscr...@googlegroups.com.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
