给老师一封信100字作文:Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

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
.................