11.asp

来自「本学期要实讯」· ASP 代码 · 共 20 行

<!--#include file="odbc_connection.asp"-->
<% dim rs,sql
  name=trim(request("name"))
  want=trim(request("want"))
  addr=trim(request("addr"))
%>
 <%sql="select * from cominfo where 0=0 " %>
 <%if name<>"0" then
   sql=sql+"and name like'%"&name&"%'" 
   end if
   if want<>"0" then
   sql=sql+"and want like'%"&want&"%'" 
   end if
   if addr<>"0" then
   sql=sql+"and addr like'%"&addr&"%'" 
   end if
  response.Write ""&sql%>