Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Announcements
 Announcements: New Releases
 Snitz Forums 2000 Version 3.3.03 released		  New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ckirkland
Starting Member

9 Posts
Posted - 30 August 2001 :  15:41:51  Show Profile  Visit ckirkland's Homepage
http://204.185.108.218/snitz/members.asp

will not display
 Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Function sequence error
/snitz/members.asp, line 225
Go to Top of Page

Twig
Starting Member

5 Posts
Posted - 31 August 2001 :  05:13:04  Show Profile
There still seems to be a problem with the sorting of members.
This topic (http://forum.snitz.com/forum/topic.asp?TOPIC_ID=12511) says it is fixed in v 3.3 but it isn't in the zip file sf2k_v33_02up033.zip

In members.asp change:
lastheredatedasc to lastheredateasc.

and:

case "levelasc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_TITLE ASC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
case "leveldesc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_TITLE DESC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
to:
case "levelasc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_LEVEL ASC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
case "leveldesc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_LEVEL DESC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"

And I found I had to change the following to make the first name search work after doing an 'All' initial search:

<input type="hidden" name="initial" value="<%= srchInitial %>">
to
<input type="hidden" name="initial" value="">

The search/sort is working fine for us now.
Twig
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 31 August 2001 :  20:42:25  Show Profile
members.asp. Sorting problem. See here as well.

http://forum.snitz.com/forum/topic.asp?ARCHIVE=&TOPIC_ID=16131

Share A Square at forumSquare

GauravBhabu
There is only one miracle...That is LIFE!
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 01 September 2001 :  00:46:55  Show Profile  Visit gor's Homepage
Sorry that I didn't lock this topic sooner.
Please post your support-questions for this version here: http://forum.snitz.com/forum/forum.asp?FORUM_ID=34

Pierre
Join a Snitz Mailinglist
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07