ASP 搜索问题

来源：百度知道 编辑：UC知道 时间：2024/09/18 05:14:10
我做了简单的搜索功能
from是这样的
<form action="newsearch.asp" method="get" name="" target="_parent">
<input name="keyword" type="text" id="keyword" size="40">
<input type="image" src="image/search/search.gif" onclick="search()" align="absMiddle" width="45" height="21" hspace="0" border="0"> </form>

搜索部分是这样的
<%
fazhan=request("fazhan")
daozhan=request("daozhan")
keyword=request("keyword")
shifa=request("shifa")
if keyword="" and shifa="" and daozhan<>"" then
set showsearch=server.createobject("ADODB.Recordset")
sql="select * from search where fazhan='"&fazhan&"

不需要空格吗？

fazhan=replace(request("fazhan")," ","")
daozhan=replace(request("daozhan")," ","")
keyword=replace(request("keyword")," ","")
shifa=replace(request("shifa")," ","")

1、你要去单引号才对，首尾空格；
2、你这种判断，有BUG吧，我认为这样写会好点

fazhan=Replace(Trim(request("fazhan")),"'","")
daozhan=Replace(Trim(request("daozhan")),"'","")
keyword=Replace(Trim(request("keyword")),"'","")
shifa=Replace(Trim(request("shifa")),"'","")
Dim sql
sql = "select * from search where id<>0 "
If fazhan<>"" Then sql = sql & " and fazhan='"&fazhan&"'"
......
If keyword<>"" Then sql = sql & " and keyword