On Sunday, April 7, 2013 5:19:24 PM UTC-7, Gabriel Correa wrote:
> Hello,
>
> I'm new to Sequel and having trouble getting it to produce the following
> SQL.
>
> SELECT id, name, ( 3959 * acos( cos( radians(PLACEHOLDER) ) * cos(
> radians( latitude ) ) * cos( radians( longitude ) - radians(PLACEHOLDER) )
> + sin( radians(PLACEHOLDER) ) * sin( radians( latitude ) ) ) ) as distance
> from chapters order by distance
>
I'm not sure if I got all the parens right, but something like this should
work:
DB[:chapters].
select{[:id, :name, (Sequel.expr(3959) * acos(cos(radians(PLACEHOLDER))
* cos(radians(latitude))) * cos(radians(longitude) - radians(PLACEHOLDER))
+ sin(radians(PLACEHOLDER)) * sin(radians(latitude))).as(:distance)]}.
order(:distance)
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
