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.70914342999458 45.39688298831242,-75.70073202252388 45.382778140918234,-75.70227697491646 45.37457883448438,-75.69815710186958 45.36963456045664,-75.69541051983833 45.37168467775233,-75.6980712711811 45.37777429382285,-75.6882007420063 45.38205472052984,-75.68390920758247 45.37735226237295,-75.68073347210884 45.37264941311944,-75.66820219159126 45.368307974372875,-75.66322401165962 45.37065962839337,-75.66751554608345 45.37885950308748,-75.67592695355415 45.3879623828148,-75.67781522870064 45.389589895579775,-75.67086294293404 45.399775855279145,-75.6688030064106 45.40290962735953,-75.66948965191841 45.40586244583094,-75.67309454083443 45.410502277311515,-75.67094877362251 45.41333419492406,-75.67352369427681 45.41652746358743,-75.70201948285103 45.40483801609086,-75.69970205426216 45.400920907537866,-75.70914342999458 45.39688298831242)))', 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','condo apt','duplex','fourplex','garden home','house','modular','multi-family','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: Page=3&PageAction=ViewSubCat&URL=/communities/capital/
Script Name: /index.asp