Usin llblgen 3.0 where is what I am tryin to achieve.
I have a table called listings which contains 2 double fields (long and lat).
I would like to find all the POI's around a certian POI (I will provide the long/lat) and the radius distance.
Without having to convert my fields from double to spatial, can this be done easily?
If so how can the query be written to get this.
I would rather go with the route above as I do not want to convert my fields to spatial.
However, if the above cannot be achieved easily, after I convert my fields to spatials, what do i need to know, i read that I will need the sql server assembly in the gac, is this still true?
If after I convert my fields to spatials, what do i need to do to still be able to use llblgen objects, would i need to put the distance calculator in SP or can i juse use the predicate system built in to llblgen?
I guess I am looking for as much information as possible to simply get POI's around a POI within a x radius
Thanks
