Contact Us:
314.329.3828
Login
Home
Services
DNN
Modules
Articles
Advanced DataGrid
Categories
Mailing List Subscribe
Module Discussions
Blog
About Efficion
Contact Us
Module Discussions
Forums
Search Forum
Search
Advanced Search
Topics
Posts
Unanswered
Active Topics
Prev
Go to previous topic
Next
Go to next topic
Forums
Efficion Articles Module for DotNetNuke
Bug Reports
Last Post 9/4/2010 1:31 PM by
David O'Leary
Under SQL 2000, the Create Procedure for Articles_GetArticles fails
0 Replies
Sort:
Oldest First
Most Recent First
Please login to post a reply.
Author
Messages
David O'Leary
Efficion Consulting Staff
Basic Member
Posts:151
9/4/2010 1:31 PM
SQL 2000 does not support Variables within the OrderBy statement. We use NewID() for the Random Sort option but this will fail if your running SQL 2000 or a newer version in SQL 2000 compatibility mode.
The error message you'll see is:
The SELECT item identified by the ORDER BY number 6 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.
To resolve this problem, use SQL 2005 or newer, or remove this line from the Articles_GetArticles Stored Procedure: CASE @SortField WHEN 'Random' THEN NewID() END
Please login to post a reply.
Efficion Articles Module for DotNetNuke
--Help, Tips, Tricks, and Tutori...
--Version/Release Information
--Feature Requests
--Bug Reports
--General Feedback and Discussio...
--Templates
--Translations
Other Modules
--Advanced DataGrid Module
--Categories
--Mailing List Subscribe
--What's New Module
Forums
Efficion Articles Module for DotNetNuke
Bug Reports
Copyright © 2004 - 2021 Efficion Consulting