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(101,76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-75.55967330932617 45.47891056740279,-75.5533218383789 45.46627091868822,-75.54611206054688 45.469762152630416,-75.5394172668457 45.463863045153346,-75.55280685424805 45.46085305860481,-75.54130554199219 45.440139995004664,-75.53804397583008 45.441826226418996,-75.5251693725586 45.42279297541518,-75.48328399658203 45.41809390672581,-75.4896354675293 45.42941920248723,-75.44809341430664 45.44230799756669,-75.4489517211914 45.44459635433677,-75.44088363647461 45.44700505065907,-75.44672012329102 45.45736127288332,-75.46680450439453 45.454350939222046,-75.46577453613281 45.46422423274014,-75.44620513916016 45.47036406766186,-75.4489517211914 45.47204939555312,-75.43968200683594 45.474095797384656,-75.47470092773438 45.49022365762068,-75.47796249389648 45.48865921668584,-75.48620223999023 45.50141416006349,-75.4789924621582 45.50815145444449,-75.48826217651367 45.51103861949328,-75.55967330932617 45.47891056740279)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/orleans/
Script Name: /index.asp