<%
key1=trim(request(keyword1))
key2=trim(request(keyword2))
key3=trim(request(keyword3))
sql="select * from tablename where (key1='"&key1&"'and key2<>'"&key2&"' and key3<>'"&key3&"') or (key2='"&key2&"''and key1<>'"&key1&"' and key3<>'"&key3&"' ) or( key3='"key3"' 'and key2<>'"&key2&"' and key1<>'"&key1&"')or ( key1='"&key1"'and key2='"&key2&"' and key3='"&key3&"')
%>
if a1<>"" then
sql=sql&" a1 like '%"&a1&"%' and "
end if
if a2<>"" then
sql=sql&" a2 like '%"&a2&"%' and "
end if
if a3<>"" then
sql=sql&" a3 like '%"&a3&"%' and "
end if
if sort="topic" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
rs.open "select * from xinwen where title like '%" & key & "%' order by newsid DESC",conn,1,1
str="按文章标题查找"
end if
if sort="content" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
rs.open "select * from xinwen where content like '%" & key & "%' order by newsid DESC",conn,1,1
str="按文章内容查找"
end if
%>