asp 操作操作符丢失丢失

来源：百度知道 编辑：UC知道 时间：2024/05/10 20:18:04
<%
portname=request("portname")
linename=request("linename")
shipcompany=request("shipcompany")
bytime=request("bytime")

sql="select * from Price where "

if portname <>"" then
Sql= Sql & "and PurposeHarbor like '%"&portname&"%'"
end if
if linename<>"" then
sql=sql&"and linename= "&linename&""
end if
if shipcompany<>"" then
sql=sql&"and BoatCompany like '%"&shipcompany&"%'"
end if

sql=sql&"order by PurposeHarbor asc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1

rs.pagesize=17
pagecount=rs.pagecount
%>

提交以后出现:
Microsoft JET Database Engine 错误 '80040e14'

语法错

<%
portname=request("portname")
linename=request("linename")
shipcompany=request("shipcompany")
bytime=request("bytime")

sql="select * from Price where 1=1 "

if portname <>"" then
Sql= Sql & "and PurposeHarbor like '%"&portname&"%'"
end if
if linename<>"" then
sql=sql&"and linename= "&linename&""
end if
if shipcompany<>"" then
sql=sql&"and BoatCompany like '%"&shipcompany&"%'"
end if

sql=sql&"order by PurposeHarbor asc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1

rs.pagesize=17
pagecount=rs.pagecount
%>

你where后面直接是and操作符了
Sql初始化改为：
asp 操作操作符丢失丢失

sql="select * from Price where 1=1 "