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 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-114.0413097614674 53.55487121696291,-114.00199930614514 53.55538109339053,-114.00182764476818 53.5482422642587,-113.95908396190686 53.54854823877987,-113.9589123005299 53.52457353381834,-113.97007029003186 53.524471484789096,-113.97007029003186 53.50237806361249,-114.02689020580334 53.501969652160376,-114.02671854442639 53.51248499331804,-114.05092279857678 53.51187252072815,-114.05127473239844 53.54089571615586,-114.04039515066279 53.541079848303575,-114.0413097614674 53.55487121696291)))', 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/stony-plain/
Script Name: /index.asp