% response.expires = 0 %>
<%
page=sqlCheck(request("page"))
such_c = sqlCheck(request("such_c"))
such_v = sqlCheck(request("such_v"))
cap=sqlCheck(request("cap"))
cap1=sqlCheck(request("cap1"))
cap2=sqlCheck(request("cap2"))
if sqlCheck(request("page"))="" then
page=1
end if
'sql = "select distinct basket_id money_plane from buying where "&such_c&" like '%"&such_v&"%' order by basket_id desc"
if such_c <> "" and such_v <> "" then
'sql="select * from membership where "&such_c&" like '%"&such_v&"%' order by num desc"
sql="select distinct work from membership where "&such_c&" like '%"&such_v&"%' and work !='' order by work asc"
else
if cap <> "" and cap1 <> "" then
'sql="select * from membership where "&cap&" like '%"&cap1&"%' order by num desc"
sql="select distinct work from membership where "&cap&" like '%"&cap1&"%' and work !='' order by work asc"
else
'sql="select * from membership order by work asc"
sql="select distinct work from membership where work !=''order by work asc"
'sql="select max(sno),work from membership group by work"
'select distinct aaa, bbb from TABLE group by aaa
end if
end if
set rs=server.CreateObject ("adodb.recordset")
rs.PageSize = 10
rs.Open sql,conn,1
%>
|
|||||||||||||||||||||||||||||||