ASP程序调试,语句未结束!!急急!!!!!!!!

来源:百度知道 编辑:UC知道 时间:2024/06/03 18:45:58
<%
session("replynum")=request.QueryString("id")
authorid=trim(request.QueryString("id"))
set rs=server.CreateObject("ADODB.Recordset")
rs.open"select * from bbsarticle where ID='"authorid"' or replynum='"authorid"' order by postdate desc",conn,3,3
rs.pagesize=10
rs.absolutepage=1
%>
我把你们说的改了,也把单引号去了!
可是人家又提示是:字符串的语法错误 在查询表达式 'ID=1'or replynum=1 order by postdate desc'
是咋会事啊!
再帮忙看下!
谢谢!

authorid是变量要连接起来
rs.open"select * from bbsarticle where ID='"&authorid&"' or replynum='"&authorid&"' order by postdate desc",conn,3,3

<%
session("replynum")=request.QueryString("id")
authorid=trim(request.QueryString("id"))
set rs=server.CreateObject("ADODB.Recordset")
rs.open "select * from bbsarticle where ID='"&authorid&"' or replynum='"&authorid&"' order by postdate desc",conn,3,3
rs.pagesize=10
rs.absolutepage=1
%>

变量和字符串要用&链接!这是ASP的语法!