% response.expires = 0 %> <% page = sqlCheck(request("page")) such_c = sqlCheck(request("such_c")) such_v = sqlCheck(request("such_v")) such_v2 = sqlCheck(request("such_v2")) such_v3 = sqlCheck(request("such_v3")) if sqlCheck(request("page"))="" then page=1 end if if such_v3 <> "" then orderby = " order by " &such_v3&" asc" else orderby = " order by sno asc" end if '###########gubun ºÐ·ù°Ë»ö################# if such_c <> "" and (such_v <> "" or such_v2 <> "") then if such_c = "gubun" then sql="select * from membership where " &such_c& " like '%"&such_v2&"%' " & orderby elseif such_c = "homeAddr" then sql="select * from membership where homeAddr like '%"&such_v&"%' or homeAddr2 like '%"&such_v&"%' " & orderby else sql="select * from membership where "&such_c&" like '%"&such_v&"%' " & orderby end if else sql="select * from membership " & orderby end if 'response.write sql set rs=server.CreateObject ("adodb.recordset") rs.PageSize = 20 rs.Open sql,conn,1 %>
|
||||||||||||||||||||||