When the subject line in my forum has the chracter like "|", it will shop up some the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean OR, type equals varchar. /inc_top.asp, line 233
Do you have the active users mod installed? since the error occurs in inc_top, I am assuming that you do, since there is no code which processes the subject line in inc_top, other than this, so it may be a problem with that.
I have tested it here, and the error does not occur, do you have a URL I can look at.
Yes, I did have active users installed. And I used another version with no active users installed. There won't have this problem at all. So, Should I change anything on active users code to make it work?? The url is http://queerbbs.com/forum.asp?FORUM_ID=13&CAT_ID=1&Forum_Title=test You can test the post on the top with subject "abc |". Thanks a lot.
Function OnlineSQLencode(byVal strPass) If not isNull(strPass) and strPass <> "" Then strPass = Replace(strPass, "%", "'%'") strPass = Replace(strPass, "'", "''") strPass = Replace(strPass, "|", "'|'") OnlineSQLencode = strPass End If End Function
Remove the two lines in red, they are not required
Topic Locked
Posted - 30 June 2001 : 20:27:14
