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]<javascript:> > > 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; >> >> >> >> > --
