错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
列名 'zlbuserId' 无效。
/operation/company/deletedCClientList.asp, 第 70 行
0" '红海的客户不显示
end if
if companyKey"" then
KeyArr = GetKeyArr(companyKey)
dim getKeyArrN
for i = 0 to ubound(KeyArr)
getKeyArrN = forSqlLike(KeyArr(i))
sql = sql + " and ( companyName like '%" & getKeyArrN &"%' or otherName like '%" & getKeyArrN &"%' ) "
next
end if
if addressKey"" then
KeyArr = GetKeyArr(addressKey)
for i = 0 to ubound(KeyArr)
sql = sql + " and addresslike '%" & forSqlLike(KeyArr(i))&"%' "
next
end if
if contactKey"" then
KeyArr = GetKeyArr(contactKey)
for i = 0 to ubound(KeyArr)
sql = sql + " and contectNamelike '%" & forSqlLike(KeyArr(i))&"%' "
next
end if
if phoneKey"" then
KeyArr = GetKeyArr(phoneKey)
for i = 0 to ubound(KeyArr)
sql = sql + " and ( phone like '%" & forSqlLike(KeyArr(i))&"%' or mobile like '%" & forSqlLike(KeyArr(i))&"%' ) "
next
end if
if userName "" then sql = sql & " and userName like '%" & forSqlLike(userName)& "%' "
sql = sql & " order by followDate desc, deleteDate desc "
set rs = Server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
set pg = new SophyPage
pg.head
%>
第70行:rs.open sql,conn,1,1
|