谁来帮我修正一段ASP代码

来源:百度知道 编辑:UC知道 时间:2024/05/11 19:13:13
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/database.mdb")
%>

<%dim exec,exec1,rs1

exec="Select C.ArticleID,A.ArticleID,A.title From comment C,Article A where C.com='true' and C.ArticleID=A.ArticleID"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1

exec1="Select Count(*) From comment C,Article A where C.com='true' and C.ArticleID=A.ArticleID"
set rs1=server.createobject("adodb.recordset")
rs1.open exec1,conn,1,1

%>
<% dim tiaoshu
tiaoshu = Conn.Execute("Select Count('ArticleID') From comment where com='true' and ArticleID ="&rs("ArticleID")&"")(0)
%>

'================================

<table width="

我在汗你那个显示结果呢…………爷们你弄个本地文件放那是给谁看的?

显示结果为 http://localhost/baby/ShowArticle11_tptj.asp

郁闷了…………

IIS报错打上来!

得了 我知道了!!!

exec="Select C.ArticleID,A.ArticleID,A.title From comment C,Article A where C.com='true' and C.ArticleID=A.ArticleID"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1

Select C.ArticleID,A.ArticleID,A.title From comment 该成Select * From comment 就行了!前提是必须在数据库中有你用的那个字段,名字不能错!
汗你一下....你的EXEC语句里根本就没查找ArticleID这个字段么,下面又用rs("ArticleID"),电脑上哪找去!!!

把分拿来…………哈哈!六十分那个也给袄!!!