我在程序中定义了一个:
Dim bContent(1500) as Byte当我读出bContent的数值后要保存到数据库中,可是每次在保存的时候出错,我发现数据中包含了一些SQL语句的单引号,我已经将单引号做了替换为双引号的处理。可是就是报错:字符串的语法不正确。但是当我将这条语句放到查询分析器中执行却没有问题。例如:SQL语句是:insert into tBook (author,content) value ('" & sName & "','" CStr(bContent) & "')"
请问:谁有这方面的经验,请传授给我,以100分致谢!
Dim bContent(1500) as Byte当我读出bContent的数值后要保存到数据库中,可是每次在保存的时候出错,我发现数据中包含了一些SQL语句的单引号,我已经将单引号做了替换为双引号的处理。可是就是报错:字符串的语法不正确。但是当我将这条语句放到查询分析器中执行却没有问题。例如:SQL语句是:insert into tBook (author,content) value ('" & sName & "','" CStr(bContent) & "')"
请问:谁有这方面的经验,请传授给我,以100分致谢!
吀犡?戞?搁炖???渀掘ǚ?蟥???穤?Ё?蠡?笁??????9????︸?瀁?$?????????????潵?聑嚨縀豨h?劼??夂伀???遆焁????─?~??ā?????????1?獿??′?鰗儀?′?枌樁鹹a?蹋琁?J?稀???躓?㏑x??嬁????渁????伀礆??輵ā颃ê????戧?氀埧è?炞???衎姟????駂?孺?泌?????籼?秽/?????萡???茠?鱗??缀????????????戫颦?崋h?漃?????企r?湤栀奎??遮码?瘈???ě?壗吁??弋??鷙?褊?????掖??£?诧甁???????鉲擆?????笀?ǘ餞尯?散G?唝 ????樁遑-赡??????眀?橿訳????硣崀歎?佯伩???鰓????稉彊??????????缀????瀀??け償????戧???????吜?丁卫???椀?à?第洁陪_?趆??"???茟???最???避洀????????冺????駇樁榝?桕???e?鈘?稳W?镱最???麃崁????瘁??蔙??ó浈??????一敪¨?窺?弮??聩ā阇??辂?祚?','1','',0,'','1','1','0','')
select
'" & replace(sName,"'","''") & "','" & replace(CStr(bContent),"'","'') & "'"就是将一个单引号换成两个单引号即可
bContent = Replace(bContent, "'", "''")
SQL = "insert into tBook (author,content) value ('" & sName & "','" & CStr(bContent) & "')"