sp1000je
63 lines
1.5 KiB
Plaintext
63 lines
1.5 KiB
Plaintext
<!--#include virtual ="/common/lib/dbcon.asp"-->
|
|
<!--#include virtual ="/common/lib/func.asp"-->
|
|
<%
|
|
Dim sch_member, sch_field
|
|
|
|
sch_member = InputValue(request("sch_member"))
|
|
sch_field = InputValue(request("sch_field"))
|
|
|
|
%>
|
|
<link rel="Stylesheet" type="text/css" href="/manager/common/css/all.css" />
|
|
<script type="text/javascript">
|
|
<!--
|
|
function return_value(m_id) {
|
|
|
|
|
|
var a_ad_cms_id = window.parent.document.getElementById("frm").a_ad_cms_id.value
|
|
|
|
if(a_ad_cms_id == ""){
|
|
window.parent.document.getElementById("frm").a_ad_cms_id.value = m_id + ",";
|
|
}else{
|
|
window.parent.document.getElementById("frm").a_ad_cms_id.value = a_ad_cms_id + m_id + ",";
|
|
}
|
|
|
|
|
|
}
|
|
//-->
|
|
</script>
|
|
<body>
|
|
<%
|
|
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
|
|
%>
|
|
<font color="#008E8B">등록된 데이터가 없습니다.</font>
|
|
<%
|
|
Else
|
|
|
|
Do Until rs1.eof
|
|
m_id = rs1("m_id")
|
|
m_name = trim(rs1("m_name"))
|
|
lvlname = trim(rs1("lvlname"))
|
|
%>
|
|
<a href="javascript:return_value('<%=m_id%>')"><%=m_name%> (<%=m_id%>)(<%=lvlname%>)</a><br><img width="0" height="6"><br>
|
|
<%
|
|
|
|
rs1.movenext
|
|
loop
|
|
End If
|
|
End if
|
|
%>
|
|
|
|
</body>
|
|
</html>
|
|
<%
|
|
dbcon.close
|
|
Set dbcon = nothing
|
|
%> |