做了一函数如下:
function Count_hits(id){
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn ="Driver={SQL Server};Server=.;Database=shdb;UID=shdb;PWD=shdbpwd"
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("update DJ set hits=hits+1 where id="&id&"");
用同样的方式,要把人气统计显法出来,怎么显示不了,
ShowHits文件如下
Dim id,rshits,sqlhits,hits
id = request("id")
set rshits = server.CreateObject("adodb.recordset")
sqlhits = "select hits from DJ where id="&id
rshits.open sqlhits,conn,1,3
if not(rshits.eof or rshits.bof) then
hits=rshits("hits")
end if
rshits.close
set rshits=nothing
response.Write(hits)
单独运行这文件,能显示hits值。直接输出的。
在html中调用就显示不了hits值了,调用方式<script src=ShowHits.asp?id=7693></script>
请问是为什么啊?
做了一函数如下:
function Count_hits(id){
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn ="Driver={SQL Server};Server=.;Database=shdb;UID=shdb;PWD=shdbpwd"
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("update DJ set hits=hits+1 where id="&id&"");