产品使用及交流论坛

注册

 

QQ登录

只需一步,快速开始

发新话题 回复该主题

商业用户,从ACCESS转为SQL,出现的问题。(论坛上有的方法不能解... [复制链接]

1#
之前是ACCESS数据库,买了商业版后。V3的网站统计就失效了,也按照这个解决办法全部修改了(修改方法:http://bbs.pageadmin.net/showtopic-23941.aspx)。但是还是错误的。如图:

网址:www.ynqljx.com





自定义文件代码如下:


<head>
<style type="text/css">
div{font:12px/1.7em Verdana,Tahoma,Helvetica,Arial,sans-serif;}
div .hs{color:#ff0000}
</style>
</head>
<body bgColor="transparent">
<div>
○- 文章总数:<span class="hs"><%=Get_Data("co","select count(id) as co from article")%></span><br>
○- 今日文章:<span class="hs"><%=Get_Data("co","select count(id) as co from article where datediff(day,thedate,getdate())=0")%></span><br>
○- 会员总数:<span class="hs"><%=Get_Data("co","select count(id) as co from pa_member")%></span><br>
○- 最新会员:<span class="hs"><%=Get_Data("username","select top 1 username from pa_member order by id desc")%></span><br>
○- 访问总数:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count")%></span><br>
○- 本月访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff(month,thedate,getdate())=0")%></span><br>
○- 今日访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff(day,thedate,getdate())=0")%></span><br>
</div>
分享 转发
好合数据—领先的互联网应用服务提供商:  www.cnhaohe.com
TOP
2#

知道的帮忙看看?
好合数据—领先的互联网应用服务提供商:  www.cnhaohe.com
TOP
发新话题 回复该主题