编程论坛 → ASP技术论坛

请教一下多关键字搜索的一个问题

cmd2007 发布于 2008-07-31 22:52， 1067 次点击

<%
set conn = server.CreateObject("adodb.connection")
  conn.open "dbq="&server.MapPath("gs.mdb")&";driver={microsoft access driver (*.mdb)}"

  setok = request("jian")
  if trim("setok") = "" then
  response.Write "<script>alert('请输入关键字');history.back();</script>"
  response.End
  end if
  setok = rtrim(ltrim(setok))
  setok2 =split(setok," ")
  max=ubound(setok2)

  for i=0 to max
  if  i = 0 then
  sql1=sql1&" (key like '%" & setok2(i) & "%' and "
  else
  if i = max then
  sql1=sql1&" key like '%" & setok2(i) & "%') "
  else
  sql1=sql1&" key like '%" & setok2(i) & "%' and "
  end if
  end if
  next

   sql = "select * from yuangong where  "&sql1&"    "
   response.Write sql

   %>
  <p><span class="STYLE1">姓名</span>：   <%=rs("xingming")%>    </p>
                      <p><span class="STYLE1">年龄</span>：   <%=rs("nianling")%>                        </p>
                      <p><span class="STYLE1">户籍</span>：   <%=rs("huji")%>                        </p>
                      <p><span class="STYLE1">学历</span>：   <%=rs("xueli")%>                        </p>
                      <p><span class="STYLE1">职位</span>：   <%=rs("zhiwei")%>                        </p>
                      <p><span class="STYLE1">电话</span>：<%=rs("lianxi")%>                        </p>
                      <p><span class="STYLE1">履历</span>：<%=rs("jingli")%>                        </p>

请教一下我如何让上面的代码显示出我搜索的内容    现在还显示不出数据库的内容
需要怎么改一下谢谢大家

5 回复

#2

madpbpl2008-08-01 02:03

set rs = Server.createObject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof
............ '你想显示的内容
rs.movenext
loop

#3

cmd20072008-08-01 10:24

回复 2# madpbpl 的帖子

谢谢你的答复按照这个方法我加在了sql = "select * from yuangong where "&sql1&" "的下面

它出现WHERE 子句语法错误需要怎么改一下才可以?

#4

tianyu1232008-08-01 11:21

输出SQL语句好好检查一下

#5

hmhz2008-08-01 11:24

多词查询一个字段的用 in()

#6

cmd20072008-08-01 20:05

回复 5# hmhz 的帖子

版主你好可以说的详细点吗
sql = "select * from yuangong where "&sql1&" "
这句话输入后变成select * from yuangong where (key like '%小毛%' and key like '%我%') 是没错我现在想执行它

1