Web Wiz Support and Community Forums : A Bug in Version 7.6! https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 21:16:25 +0000 Mon, 15 Dec 2003 13:22:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8040 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[A Bug in Version 7.6! : test49 wrote: Pedigree, Are...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41516.html#41516 Author: thekiwi
Subject: 8040
Posted: 15 December 2003 at 1:22pm

Originally posted by test49 test49 wrote:

Pedigree,

Are you saying that most of the search function is a uncompleted task?

Regards
Chris

No ... from my tests it only affects a search where you select "username" and then sort by a field which isn't part of that "select" statement, eg. Topic Start Date

]]> Mon, 15 Dec 2003 13:22:08 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41516.html#41516 <![CDATA[A Bug in Version 7.6! : Pedigree, Are you saying that...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41411.html#41411 Author: test49
Subject: 8040
Posted: 15 December 2003 at 5:48am

Pedigree,

Are you saying that most of the search function is a uncompleted task?

Regards
Chris

]]> Mon, 15 Dec 2003 05:48:11 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41411.html#41411 <![CDATA[A Bug in Version 7.6! : Borg, I would suggest that you...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41112.html#41112 Author: test49
Subject: 8040
Posted: 13 December 2003 at 9:35am

Borg,

I would suggest that you fix the search page completely before the release of version 7.7

Regards
Chris

]]> Sat, 13 Dec 2003 09:35:38 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41112.html#41112 <![CDATA[A Bug in Version 7.6! : infact, most of the searching...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41104.html#41104 Author: pedigree
Subject: 8040
Posted: 13 December 2003 at 9:10am

infact, most of the searching doesnt work correctly.

Line 227 in search.asp should read

strSQLResultsQuery = "SELECT " & strDbTable & "Topic.Start_date, " & strDbTable & "Topic.Topic_ID, " & strDbTable & "Topic.Forum_ID, " & strDbTable & "Topic.Poll_ID, " & strDbTable & "Topic.No_of_views, " & strDbTable & "Topic.Subject "

instead of

strSQLResultsQuery = "SELECT " & strDbTable & "Topic.Topic_ID, " & strDbTable & "Topic.Forum_ID, " & strDbTable & "Topic.Poll_ID, " & strDbTable & "Topic.No_of_views, " & strDbTable & "Topic.Subject "



Edited by pedigree]]> Sat, 13 Dec 2003 09:10:00 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post41104.html#41104 <![CDATA[A Bug in Version 7.6! : Bruce this only happens when you...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post40991.html#40991 Author: dj air
Subject: 8040
Posted: 12 December 2003 at 1:02pm

Bruce this only happens when you have search in username and sort by topic start date.. with any value

its not only in V7.6 its also V7.7alpha

]]> Fri, 12 Dec 2003 13:02:57 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post40991.html#40991 <![CDATA[A Bug in Version 7.6! : Hi, I was just going to search...]]> https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post40985.html#40985 Author: test49
Subject: 8040
Posted: 12 December 2003 at 12:37pm

Hi,

I was just going to search for a username when I got this errormessage after pressing the search button:

Microsoft OLE DB Provider for SQL Server error '80040e14'

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

/forum/search.asp, line 356

I was using this forums search function here on webwiz.net!

I wrote "Test49" in the search field, selected "Usernames" from the dropdown menu, chosed "search in All forums" and sort by; "Topic starter date"

What's wrong? I tested it out on Invisionportal.com too, and the same happend there.

Regards
Chris



Edited by test49]]> Fri, 12 Dec 2003 12:37:46 +0000 https://forums.webwiz.net/a-bug-in-version-7-6_topic8040_post40985.html#40985