hey thanks I was able to get it to working using that MySQL query and Web2py's executesql method
*cheers On Mon, Aug 27, 2012 at 7:46 AM, howesc <[email protected]> wrote: > if you are doing GEO stuff i would highly recommend postrgres with > postgis! then you can just ask for a point, point in polygon, polygon > contains point etc. > > On Sunday, August 26, 2012 8:54:40 PM UTC-7, Andrew Evans wrote: >> >> nvm just found acos cos and such are not available in Dal or sqlite and I >> will need to use mysql >> >> *cheers >> >> ty :D >> >> >> >> On Sun, Aug 26, 2012 at 8:43 PM, Andrew Evans <[email protected]>wrote: >> >>> I was able to figure out the jquery side of things and found a query >>> that suggests a way to do this. How can I do this below query in DAL using >>> SQLite ;-) >>> >>> *cheers >>> >>> SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( >>> radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) >>> ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT >>> 0 , 20; >>> >>> >>> >>> >> -- > > > > --
