%
'memgr_logincookie "itech", "qhdkswjqth"
Dim searchType, searchValue
searchType = inputValue(Request.QueryString("searchType"))
searchValue = inputValue(Request.QueryString("searchValue"))
If searchType = "m_mobile" Then
searchTypeQ = "m_mobile1+m_mobile2+m_mobile3"
searchValue = Replace(searchValue, "-", "")
else
searchTypeQ = searchType
End if
If searchValue <> "" Then
If searchValue = "all" Then
sql = "select m_name, m_mobile1+m_mobile2+m_mobile3 from member where m_level <> 2"
else
sql = "select m_name, m_mobile1+m_mobile2+m_mobile3 from member where " & searchTypeQ & " like '%" & searchValue & "%'"
End if
'response.write sql
Set rs = Dbcon.Execute( sql )
If rs.bof Or rs.eof Then
mem_list = Null
Else
mem_list = rs.getrows
End If
Set rs = nothing
Else
mem_list = null
End If
%>