<%
vtxtfind=request("txtfind")
'response.write(vtxtfind)
'cQuery = "select * from km_search where search_name like '%" & vtxtfind & "%' or search_key like '%" & vtxtfind & "%'"
cQuery = "select * from plan2 where subject like '%" & vtxtfind & "%' or name like '%" & vtxtfind & "%'"
'cQuery = "select * from plan2 "
'response.write(cQuery)
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "km_odbc","spd","spd"
set master = server.CreateObject("ADODB.Recordset")
master.open cQuery,conn,1,3
%>
<%
vtxtfind=request("txtfind")
'response.write(vtxtfind)
'cQuery = "select * from km_search where search_name like '%" & vtxtfind & "%' or search_key like '%" & vtxtfind & "%'"
cQuery = "select * from plan2 where subject like '%" & vtxtfind & "%' or name like '%" & vtxtfind & "%'"
'cQuery = "select * from plan2 "
'response.write(cQuery)
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "km_odbc","spd","spd"
set master = server.CreateObject("ADODB.Recordset")
master.open cQuery,conn,1,3
%>
ลำดับ
งานที่เชี่ยวชาญ
ชื่อผู้เชี่ยวชาญ
<%
c = 0
Do while not master.eof
c = c+1
%>
<%=c%>
<%=master("subject")%>
<%=master("name")%>
<% master.movenext
Loop
master.CLOSE %>
" ; ?>
<%
vtxtfind=request("txtfind")
'response.write(vtxtfind)
'cQuery = "select * from km_search where search_name like '%" & vtxtfind & "%' or search_key like '%" & vtxtfind & "%'"
cQuery = "select * from plan2 where subject like '%" & vtxtfind & "%' or name like '%" & vtxtfind & "%'"
'cQuery = "select * from plan2 "
'response.write(cQuery)
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "km_odbc","spd","spd"
set master = server.CreateObject("ADODB.Recordset")
master.open cQuery,conn,1,3
%>
ย้อนกลับ