err#-2147217900
err desc:Could not find method 'stgeomfromtext' for type 'Microsoft.SqlServer.Types.SqlGeometry' in assembly 'Microsoft.SqlServer.Types'
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(17) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-79.96463106171876 44.571906147500826,-79.80807588593751 44.65402458944436,-79.72018526093751 44.571906147500826,-79.75314424531251 44.54059238894919,-79.61169527070314 44.420073268234695,-79.69409273164064 44.405358783724346,-79.74215791718751 44.39162192462784,-79.74215791718751 44.33565998946995,-79.80670259492189 44.3435175210802,-79.96188447968751 44.50044700987534,-79.91381929414064 44.5347191832608,-79.96463106171876 44.571906147500826)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/springwater/
Script Name: /index.asp