ps白底怎么换蓝底照片:Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 10:47:29
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
不能比较或排序 text、ntext 和 image 数据类型,除非使用 IS NULL 或 LIKE 运算符。
/love/sub/online.asp,行 11
这个问题怎么解决
<%
Sub online()
dim username,sex,grade,UserIP
if Request.Cookies(Application("my_url"))("huiyuan")="" then
msum=replace(Request.ServerVariables("REMOTE_ADDR"),".","")&replace(replace(replace(replace(replace(replace(Request.ServerVariables("HTTP_USER_AGENT"),".",""),";",""),"/",""),"(",""),")","")," ","")
username="来宾"&msum
sex=""
grade=0
UserIP=Request.ServerVariables("REMOTE_ADDR")
set rs=Server.CreateObject("ADODB.recordset")
rs.open"select * from love_online where 这和下面一行是11号username='"&username&"'",conn,1,3 这和上面一行是11
if rs.eof and rs.bof then
rs.addnew
rs("username")=username
rs("sex")=sex
rs("grade")=grade
rs("ip")=UserIP
rs("logintime")=now()
rs("lasttime")=now()
rs.update
.................
不能比较或排序 text、ntext 和 image 数据类型,除非使用 IS NULL 或 LIKE 运算符。
/love/sub/online.asp,行 11
这个问题怎么解决
<%
Sub online()
dim username,sex,grade,UserIP
if Request.Cookies(Application("my_url"))("huiyuan")="" then
msum=replace(Request.ServerVariables("REMOTE_ADDR"),".","")&replace(replace(replace(replace(replace(replace(Request.ServerVariables("HTTP_USER_AGENT"),".",""),";",""),"/",""),"(",""),")","")," ","")
username="来宾"&msum
sex=""
grade=0
UserIP=Request.ServerVariables("REMOTE_ADDR")
set rs=Server.CreateObject("ADODB.recordset")
rs.open"select * from love_online where 这和下面一行是11号username='"&username&"'",conn,1,3 这和上面一行是11
if rs.eof and rs.bof then
rs.addnew
rs("username")=username
rs("sex")=sex
rs("grade")=grade
rs("ip")=UserIP
rs("logintime")=now()
rs("lasttime")=now()
rs.update
.................
问题出在这里,详细检查:
msum=replace(Request.ServerVariables("REMOTE_ADDR"),".","")&replace(replace(replace(replace(replace(replace(Request.ServerVariables("HTTP_USER_AGENT"),".",""),";",""),"/",""),"(",""),")","")," ","")
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for SQL Server 求救~~
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)