Incorrectsyntaxnear's'
来源：懂视网
责编：小采
时间：2020-11-09 15:11:41
Incorrectsyntaxnear's'
Incorrectsyntaxnear's':出错的SQL: update address set is_mapping='A',lat=39.8123779296875,lon=-74.9393539428711,Mapping_Platform='BingA',Mapping_Return_Result='High',County='04',Municipality='0406',source_
导读Incorrectsyntaxnear's':出错的SQL: update address set is_mapping='A',lat=39.8123779296875,lon=-74.9393539428711,Mapping_Platform='BingA',Mapping_Return_Result='High',County='04',Municipality='0406',source_
错误发生在：source_address='196 Veteran's Ave, West Berlin, NJ 08091' ,
这个字段里面有个单引号。
解决方案：将‘替换成’’
Code：sDisplayName.Replace(“'”, “''”)
Incorrectsyntaxnear's'
Incorrectsyntaxnear's':出错的SQL: update address set is_mapping='A',lat=39.8123779296875,lon=-74.9393539428711,Mapping_Platform='BingA',Mapping_Return_Result='High',County='04',Municipality='0406',source_
