请问各位高手 我的update语句怎么没有执行成功啊？也不报错
代码是这样的：
<%
newsid=request("newsid")
response.Write "newsid is &&&&&&&&&&&&&&"&newsid
set hitrs=server.createobject("adodb.recordset")
dim hitsqltext
hitsqltext="select co_hit from newcount"
hitrs.open hitsqltext,conn,2,1
'response.End()
%>
hitid is :
<%= hitrs("co_hit") %>
<%
set prohitrs=server.createobject("adodb.connection")
dim prohitsqltext
prohitsqltext="update newcount set co_hit = 1 where co_id = '"& hitrs("co_hit") &"'"
prohitrs.open prohitsqltext,conn,1,1
%>
很奇怪 请高手指点 asp不用很多时候了 诚恳请高手帮助
[解决办法]
set prohitrs=server.createobject("adodb.connection")<---你创建的是Connection
-------
...
prohitsqltext="update newcount set co_hit = 1 where co_id = '" & hitrs("co_hit") & "'"
conn.execute prohitsqltext
conn.close
Set conn = Nothing
