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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 (v3.4.03) BUG+FIX: MySQL bug in members.asp
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

seven
Senior Member

USA
1037 Posts

Posted - 01 October 2002 :  11:04:29  Show Profile  Visit seven's Homepage
I think I found a "miss" in members.asp

Roughly starting at line #218:
The line highlited in red should read: iMemberCount = ""


	if iPageTotal > 0 then
		set rs = Server.CreateObject("ADODB.Recordset")
		rs.open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
			arrMemberData = rs.GetRows(intGetRows)
			iMemberCount = UBound(arrMemberData, 2)
		rs.close
		set rs = nothing
	else
		iTopicCount = ""
	end if

else 'end MySql specific code





Edited by - Davio on 07 March 2003 10:39:10

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 01 October 2002 :  16:30:42  Show Profile
Here's another mysql specific one in members.asp

if strDBType = "mysql" then 'MySql specific code
	if mypage > 1 then 
		OffSet = cLng((mypage - 1) * strPageSize)
		strSql5 = " LIMIT " & OffSet & ", " & strPageSize & " "
	else
		strSql5 = " LIMIT " & strPageSize & " "
	end if


Add the bit in red to improve performance when viewing the first page.

Edited by - pweighill on 01 October 2002 17:09:28
Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 09 October 2002 :  12:43:24  Show Profile  Visit seven's Homepage
-Bump-

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 11 February 2003 :  00:23:08  Show Profile
Confirmed, the bug posted by Airilm is indeed a bug and the fix he suggests is correct.

Fixed in 3.4.04

Support Snitz Forums

Edited by - Davio on 07 March 2003 10:38:07
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 12 February 2003 :  02:00:31  Show Profile
Implemented Airilm's solution in v4b04a03...

Stop the WAR!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07