主题:[讨论]这个查询排序如何写?
其中的排序方式中selectt=0或1可以正常输出结果,selectt=2就代码错误,假如selectt=2字段值是LastTime,该怎么修改?谢谢!
源代码如下:
排序选择部分:
<select name="selectt">
<option value="0">按最新注册</option>
<option value="1">按登陆次数</option>
<option value="2">按最后登陆</option>
</select>
执行代码部分:
If Action="Search" Then
UserAddress=request("UserAddress")
selectt=request("selectt")
If UserAddress<>"" then
if selectt=0 then
sql="select * from [PPst_User] Where UserAddress like '%"&UserAddress&"%' and Level<>10 and Level<>0 and UserSex=1 order by regtime desc"
Else
sql="select * from [PPst_User] Where UserAddress like '%"&UserAddress&"%' and Level<>10 and Level<>0 and UserSex=1 order by cishu desc"
End if
Else
sql="select * from [PPst_User] Where Level<>10 and Level<>0 and UserSex=1 order by id desc"
End If
Elseif Action="" or Not Isnumeric(Action) then
<!-- sql="select * from [PPst_User] Where Level<>10 and Level<>0 and UserSex=1 order by regtime desc"
-->
Else
sql="select * from [PPst_User] Where Level="&Action&" and Level<>10 and Level<>0 and UserSex=1 order by cishu desc"
End If
%>
源代码如下:
排序选择部分:
<select name="selectt">
<option value="0">按最新注册</option>
<option value="1">按登陆次数</option>
<option value="2">按最后登陆</option>
</select>
执行代码部分:
If Action="Search" Then
UserAddress=request("UserAddress")
selectt=request("selectt")
If UserAddress<>"" then
if selectt=0 then
sql="select * from [PPst_User] Where UserAddress like '%"&UserAddress&"%' and Level<>10 and Level<>0 and UserSex=1 order by regtime desc"
Else
sql="select * from [PPst_User] Where UserAddress like '%"&UserAddress&"%' and Level<>10 and Level<>0 and UserSex=1 order by cishu desc"
End if
Else
sql="select * from [PPst_User] Where Level<>10 and Level<>0 and UserSex=1 order by id desc"
End If
Elseif Action="" or Not Isnumeric(Action) then
<!-- sql="select * from [PPst_User] Where Level<>10 and Level<>0 and UserSex=1 order by regtime desc"
-->
Else
sql="select * from [PPst_User] Where Level="&Action&" and Level<>10 and Level<>0 and UserSex=1 order by cishu desc"
End If
%>