谁来帮我修正一段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="
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"),电脑上哪找去!!!
把分拿来…………哈哈!六十分那个也给袄!!!