dress.c.lon-lon))
,limit=500
)
thanks for the response.
...and sqlalchemy.
-brent
On 1/31/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> use func.abs(q.address.lat) for the ABS function.
>
> On Jan 31, 2007, at 4:24 PM, Brent Pedersen wrote:
>
> >
> >
quot; - %f)"
sorder %= (lat,lon)
return q.select(
sajoin
,order_by=asc(sorder)
,limit=800
)
On 1/31/07, Brent Pedersen <[EMAIL PROTECTED]> wrote:
> hi, how can put custom sql in a query? specifically in this code? the
hi, how can put custom sql in a query? specifically in this code? the
problem is with the order_by. i want to pass it some custom sql:
q = session.query(Student)
sajoin = q.join_to('address')
return q.select(
sajoin,
order_by="(ABS(address.lat - %s
