怎样能将一些特使符号(如:单引好,双引号等)录入到数据库中?
怎样能将一些特使符号(如:单引好,双引号等)录入到数据库中?
如下面的代码,当我录入的数据含有单引好或双引号时就出错,怎么办?
<%
connstr="DBQ="+server.mappath("../asp.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
if (request("submit")<>"") then
title=request("title")
sql="insert into new set title='"&title&"'"
conn.Execute(sql)
Response.Write "<script language='Javascript'>"
Response.Write "window.alert('你提交的数据以成功录入数据库,请返回。');"
Response.Write "window.location.href='1.asp'"
Response.Write "</script>"
Response.End
else
%>
<form name="htmlform" method="post" action=News_add.asp onSubmit="return asubmit();">
<input type="text" name="Title">
<input type="submit" name="submit" id="submit" value=" 确 定 ">
</form>
<%
end if
%>