京剧钓金龟全剧兰文云:关于SQL的问题

来源:百度文库 编辑:高校问答 时间:2024/05/05 17:49:03
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'

/iisHelp/common/500-100.asp,行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '=' 附近有语法错误。

/browser.asp,行154

源文件~~是下面的

<%Dim objConnection,objRecordset
Dim strTemp
Dim strSQL
Dim discountPrice,CurrentPage,i
Set objConnection=Server.CreateObject("ADODB.Connection")
objConnection.Open Application("DataLink")
'response.write session("cardname")

if trim(session("cardname"))="hc206" then
strSQL="select * from carda where (ulx!='a' and ulx!='w') or ulx is null"
elseif trim(session("cardname"))="hc207" then
strSQL="select * from cardb where (ulx!='a' and ulx!='w') or ulx is null"。。。。。。。。。。。。

'response.write strSQL
Set objRecordset=Server.CreateObject("ADODB.Recordset")
objRecordset.CursorLocation=3
objRecordset.PageSize=15
objRecordset.Open strSQL,objConnection,,,1
set re=Server.CreateObject("ADODB.Recordset")
re.CursorLocation=3

IF objRecordset.EOF THEN %>
<SCRIPT LANGUAGE=javascript>
window.alert("抱歉,没有分配给你处理的客户记录,\n\n请返回。");
history.go(-1)
</SCRIPT>
<%ELSE

if Request.QueryString("ID04")="" then
CurrentPage=1
else
if clng(Request.QueryString("ID04"))<1 then
CurrentPage=1
elseif clng(Request.QueryString("ID04"))> objRecordset.PageCount then
CurrentPage=objRecordset.PageCount
else
CurrentPage=Request.QueryString("ID04")
end if
end if%>
<script language="javascript">
function funt()
{
window.location.href="browser.asp?ID04="+window.document.aa.id04.value;}

改!=为<>
问题 就一定能解决

在SQL语句中,不等于是 <> 不是 !=

select * from carda where (ulx!='a' and ulx!='w') or ulx is null

改为

select * from carda where (ulx <> 'a' and ulx <> 'w') or ulx is null