addr00=request.servervariables("server_name")
addr10=request.servervariables("url")
addr10=replace(addr10,"addvote.asp","")
addr000="http://"&addr00&addr10
voteid = request("voteid")
title = request("title")
code = "
1<script ""="" "&addr000&"="" javascript""="" language="" src="" votedy.asp?id="&voteid&"></script>
"
Sql = "Insert into dispvote(voteid,title,code,intime)VALUES('"
Sql = Sql & voteid&"','"&title&"','"& code &"',"&",Now())"
conn.execute(Sql)
这段语句应该怎样写才正确？谢谢先
赋给变量code的那一句我也不知道写的正不正确，那一句里面含有双引号等一些特殊字符
另外，values里面哪几种变量需要用单引号，哪几种不要？
---------------------------------------------------------------
字符型、日期型需要用单引号
Sql = "Insert into dispvote(voteid,title,code,intime)VALUES("&voteid&",'"&title&"','"& code &"','"&Now()&"')"
---------------------------------------------------------------
常用的数值型不需要的，其余都要
---------------------------------------------------------------
将非法字符替换成拼音的“‘等
---------------------------------------------------------------
<%
addr00=request.servervariables("server_name")
addr10=request.servervariables("url")
addr10=replace(addr10,"addvote.asp","")
addr000="http://"&addr00&addr10
voteid = request("voteid")
title = request("title")
code = "
1<script ""="" "&addr000&"="" javascript""="" language="" src="" votedy.asp?id="&voteid&"></script>
"
Sql = "Insert into dispvote(voteid,title,code,intime)VALUES("&voteid&",'"&title&"','"& code &"','"&Now()&"')"
这样写就对了