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)
 V33(.02) BUG+FIX Topic Paging when using MySQL
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 August 2001 :  07:22:19  Show Profile
open your topic.asp file.

On line #252 (or thereabouts) find this code:

	if strDBType = "mysql" then 'MySql specific code


insert the following right below that line:

		if mypage > 1 then 
intOffset = CInt((mypage-1) * strPageSize)
strSql = strSql & " LIMIT " & intOffset & ", " & strPageSize & " "
end if

Deleted
deleted

4116 Posts

Posted - 16 August 2001 :  18:31:41  Show Profile
Shall I apply this into v40b02?

Think Pink
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 17 August 2001 :  09:09:51  Show Profile  Visit gor's Homepage
yes.

BTW, really strange that that code has been deleted.

Fixed in code of version 3.3.03

Pierre
Join a Snitz Mailinglist
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.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07