代码如下
<!--#include file="conn.asp"-->
<html>
<body>
<p>
<%
dim rec
set rec= Server.CreateObject("ADODB.Recordset")
dim sql
if request("username") & ""="" then
sql="select * from guest where 内容 like '%" & request("title") & "%'"
else
sql="select * from guest where 内容 like '%" & request("title") & "%' and 用户名='" & request("username") & "'"
end if
rec.open sql , conn,1, 1 //这一行有问题
%>
<form id="form1" name="form1" method="post" action="show.asp">
姓名：
<label>
<select name="name" id="name">
<option value="" > </option>
<%do while not rec1.eof
if rec1(0)=request("name") then%>
<option value=" <%=rec1(0)%>" selected="selected"> <%=rec1(0)%> </option>
<%else%>
<option value=" <%=rec1(0)%>"> <%=rec1(0)%> </option>
