Incorrectsyntaxnear's'
來(lái)源：懂視網(wǎng)
責(zé)編：小采
時(shí)間：2020-11-09 15:11:41
Incorrectsyntaxnear's'
Incorrectsyntaxnear's':出錯(cuò)的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_
導(dǎo)讀Incorrectsyntaxnear's':出錯(cuò)的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_
錯(cuò)誤發(fā)生在：source_address='196 Veteran's Ave, West Berlin, NJ 08091' ,
這個(gè)字段里面有個(gè)單引號(hào)。
解決方案：將‘替換成’’
Code：sDisplayName.Replace(“'”, “''”)
聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Incorrectsyntaxnear's'
Incorrectsyntaxnear's':出錯(cuò)的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_
