Asp 判断是否应用样式的问题
来源:百度知道 编辑:UC知道 时间:2024/06/14 13:58:59
查询数据库
<%Set Rs2=Conn.execute("Select * From B_Class Where Order By C_Order")
判断如果查询得到得结果有任意一条满足等于Request.QueryString("Class")那么输出class="submenu"否则输出为空
我写得是Rs2("C_ID")=cint(Request.QueryString("Class")),是错误得,这样只判断乐查询出的第一条数据
求助!!
<%Set Rs2=Conn.execute("Select * From B_Class Where Order By C_Order")
判断如果查询得到得结果有任意一条满足等于Request.QueryString("Class")那么输出class="submenu"否则输出为空
我写得是Rs2("C_ID")=cint(Request.QueryString("Class")),是错误得,这样只判断乐查询出的第一条数据
求助!!
自己在网上找找
有个问题表B_Class 的字段有那些,否则就不能做满足等于
<%
dim class
class=trim(request("Class"))
Set Rs2=Conn.execute("Select * From B_Class Where Order By C_Order")
if not Rs2.eof then
class="submenu"
else
class=""
end if
方法一:
dim class
ID=cint(request("Class"))
Set Rs2=Conn.execute("Select * From B_Class Where C_ID="&ID&" Order By C_Order")
if not Rs2.eof then
class="submenu"
else
class=""
end if
方法二:
ID=cint(request("Class"))
Set Rs2=Conn.execute("Select * From B_Class Order By C_Order")
do while not rs2.eof
if Rs2("C_ID")=ID then
class="submenu"
exit do
else
class=""
end if
loop
首先你这句话就有问题:Select * From B_Class Where Order By C_Order
WHEWE语句没有条件,不然就是Select *