|
marsh171
Starting Member
USA
1 Posts |
 Posted - 08 September 2005 : 00:31:57
|
When implementing the Ouija Logged In Users MOD I get the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The text, ntext, and image data types cannot be used in an ORDER BY clause.
/forum/Default.asp, line 845
The code is copied exactly from the MOD instructions, which is as follows (line 845 in bold):
set rs = nothing
'## Forum_SQL to grab active members
strSql = "SELECT M_NAME, M_LASTACTIVE, MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " ORDER BY M_LASTACTIVE DESC;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
todaysUsersCount = 0
else
todaysUsers = rs.GetRows(adGetRowsRest)
todaysUsersCount = UBound(todaysUsers,2)
end if
rs.close
set rs = nothing
'## Forum_SQL to grab active member counts
strSql = "SELECT HIGHEST_ACTIVE_USERS_COUNT, HIGHEST_ACTIVE_USERS_DATE"
strSql = strSql & " FROM " & strTablePrefix & "TOTALS "
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
highestActiveUserCount = 1
highestActiveUserDate = strForumTimeAdjust
else
highestActiveUserCount = rs("HIGHEST_ACTIVE_USERS_COUNT")
highestActiveUserDate = rs("HIGHEST_ACTIVE_USERS_DATE")
end if
if not isDate(highestActiveUserDate) then
highestActiveUserCount = 1
highestActiveUserDate = strForumTimeAdjust
end if
rs.close
set rs = nothing
LastPostDate = ""
Any ideas? |
Regards,
Matt |
Edited by - marsh171 on 08 September 2005 00:44:06 |
|
Topic Locked
