asp做站内网页搜索
数据库包括 s_title（网页标题）s_class（网页类别）s_url(网页地址)
表单（search_in）输入搜索的关键字
"select * from search where s_title like '%" & request.form("search_in") &"%' or s_class like '%" & request.form("search_in") &"%'"
怎么将查询结果逐条显示 s_title加上网页地址 + s_class
毕业设计 很急 先谢谢了
------解决方案--------------------
set rs=server.createobject("adodb.recordset")
sql="select * from search where s_title like '%" & request.form("search_in") &"%' or s_class like '%" & request.form("search_in") &"%'"
rs.open sql,conn,1,1
if not (rs.eof and rs.bof) then
do while not rs.eof
response.write rs("s_title")&rs("s_class")&"<br>"
rs.movenext
loop
end if
rs.close
set rs=nothing
------解决方案--------------------
"<a href="""&rs("s_url")&""">"&rs("s_title")&"</a>"
------解决方案--------------------
- VBScript code
response.write "<A href=''>"&rs("title")&"</A>"