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(125, 76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-75.70004537701607 45.42719046746577,-75.67395284771919 45.416768457667864,-75.66253736615181 45.41712994686011,-75.66828802227974 45.4222507951412,-75.67112043499947 45.4286963791495,-75.64777448773384 45.43050342013797,-75.6486327946186 45.43435824755581,-75.65180853009224 45.43965820534411,-75.64846113324165 45.44056155758287,-75.66494062542915 45.44893193366569,-75.66863134503365 45.4473663462367,-75.6706054508686 45.44339196760725,-75.67189291119576 45.4419466695916,-75.67386701703072 45.441224006699144,-75.67661359906197 45.43971842927667,-75.67884519696236 45.437309421835614,-75.68888738751411 45.437068515434795,-75.69266393780708 45.438273037153984,-75.69283559918404 45.44068200345527,-75.7003028690815 45.44248866068641,-75.70365026593208 45.4272507047045,-75.70004537701607 45.42719046746577)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and type2 in ('att/row/twnhouse','commercial mix','duplex','fourplex','garden home','house','modular','multi-family','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: Page=5&PageAction=ViewSubCat&URL=/communities/rideau-vanier/
Script Name: /index.asp