加多个WHERE条件啊,不然你的选择什么都起不了用
if Request("classid") <> "" then
if Request("Nclassid") <> "" Then
sql = "SELECT [article].[articleid],[article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] where article.classid = " & Classid & " and article.Nclassid=" & Request("Nclassid") & " ORDER BY [article].[articleid] DESC"
else
sql = "SELECT [article].[articleid],[article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] where article.classid = " & Classid & " ORDER BY [article].[articleid] DESC"
end if
else
sql = "SELECT [article].[articleid],[article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] WHERE [article].[Nclassid]=[ANclass].[Nclassid] ORDER BY [article].[articleid] DESC"
end if
动感购物:
if nclassid="" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 20 qch,jj,rq,bookid,bookname,bookzz,bookchuban,shichangjia,huiyuanjia,dazhe,bookdate,bookpic from shop_books order by adddate desc",conn,1,1
else
set rs=server.CreateObject("adodb.recordset")
rs.open "select bookid,bookname,bookzz,bookchuban,shichangjia,huiyuanjia,dazhe,bookdate,bookpic from shop_books where nclassid="&nclassid&" order by adddate desc",conn,1,1
end if
是不是这个sql语句有错,不能用classid空否来取SQL值,因为只有classid不为空,才存在nclassid.麻烦高手们看一下。
if classid <> "" then
sql = "SELECT [article].[articleid],[article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] where article.classid = " & Classid & " ORDER BY [article].[articleid] DESC"
else
sql = "SELECT [article].[articleid],[article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] WHERE [article].[Nclassid]=[ANclass].[Nclassid] ORDER BY [article].[articleid] DESC"
end if