<%
Dim sch_member, sch_field
sch_member = InputValue(request("sch_member"))
sch_field = InputValue(request("sch_field"))
%>
<%
if sch_member <> "" then
If sch_field = "all" then
sql = "SELECT m_id, m_name, lvlname FROM member_view WHERE ( m_name LIKE '%" & sch_member & "%' or m_id LIKE '%" & sch_member & "%' or lvlname LIKE '%" & sch_member & "%' )"
Else
sql = "SELECT m_id, m_name, lvlname FROM member_view WHERE " & sch_field & " LIKE '%" & sch_member & "%'"
End if
Set rs1= dbcon.execute( sql )
If rs1.bof Or rs1.eof Then
%>
등록된 데이터가 없습니다.
<%
Else
Do Until rs1.eof
m_id = rs1("m_id")
m_name = trim(rs1("m_name"))
lvlname = trim(rs1("lvlname"))
%>
<%=m_name%> (<%=m_id%>)(<%=lvlname%>)
<%
rs1.movenext
loop
End If
End if
%>