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; > > > --
