Snitz Forums 2000 - Paging For forum.asp

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Paging For forum.asp

New Topic

Topic Locked

Printer Friendly

Previous Page | Next Page

Author

Topic

Page: of 3

blkrogue
New Member

USA
79 Posts

Posted - 08 August 2000 : 03:13:45

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Okay!! done.. I modified the add-on so now it supports active.asp as well. Just go and d/l the script again.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Working like a charm now, thanks !

Blkrogue

In the darkness of my soul a sparkling light has appeared

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 08 August 2000 : 07:37:59

animedj
Junior Member

USA
190 Posts

Posted - 08 August 2000 : 08:56:18

to change pagesize from 15 to 10 you have to change the following:

in active.asp look for this line:
mypagesize = 15
and change ot for
mypagesize=10

in forum.asp and topic.asp you have to look for these lines:

If mypagesize = "" then
mypagesize = 15
end if

and change it for :
If mypagesize = "" then
mypagesize = 10
end if

also you would like to look for this code in these 2 pages :

rs.cachesize = 20
rs.open strSql, my_Conn, 3

with:
rs.cachesize= mypagesize
rs.open strSql, my_Conn, 3

hope that helps.

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 08 August 2000 : 18:29:41

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
to change pagesize from 15 to 10 you have to change the following:

in active.asp look for this line:
mypagesize = 15
and change ot for
mypagesize=10

in forum.asp and topic.asp you have to look for these lines:

If mypagesize = "" then
mypagesize = 15
end if

and change it for :
If mypagesize = "" then
mypagesize = 10
end if

also you would like to look for this code in these 2 pages :

rs.cachesize = 20
rs.open strSql, my_Conn, 3

with:
rs.cachesize= mypagesize
rs.open strSql, my_Conn, 3

hope that helps.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

I also had to change the following in topic.asp :

<pre id=code>
rs.movefirst
rs.pagesize = mypagesize
maxpages = cint(rs.pagecount)
maxrecs = cint(rs.pagesize)
rs.absolutepage = mypage
howmanyrecs = 0
rec = 1
do until rs.EOF or (rec = 16)
</pre id=code>

to this:

<pre id=code>
rs.movefirst
rs.pagesize = mypagesize
maxpages = cint(rs.pagecount)
maxrecs = cint(rs.pagesize)
rs.absolutepage = mypage
howmanyrecs = 0
rec = 1
do until rs.EOF or (rec = 11)
</pre id=code>

just changing the rec = 16 to rec = 11

On or about line 219

And the following code in forum.asp :

<pre id=code>
<% rec = 1 %>
<% do until rs.EOF or (rec = 16) %>
</pre id=code>

to this

<pre id=code>
<% rec = 1 %>
<% do until rs.EOF or (rec = 11) %>
</pre id=code>

This is on or about line 211 in forum.asp

Hopefully changing these values won't mess anything up.

Edited by - Richard Kinser on 08 August 2000 18:47:41

blkrogue
New Member

USA
79 Posts

Posted - 09 August 2000 : 04:09:05

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I also had to change the following in topic.asp :

to this:

<pre id=code>
rs.movefirst
rs.pagesize = mypagesize
maxpages = cint(rs.pagecount)
maxrecs = cint(rs.pagesize)
rs.absolutepage = mypage
howmanyrecs = 0
rec = 1
do until rs.EOF or (rec = 11)
</pre id=code>

just changing the rec = 16 to rec = 11

On or about line 219

And the following code in forum.asp :

<pre id=code>
<% rec = 1 %>
<% do until rs.EOF or (rec = 16) %>
</pre id=code>

to this

<pre id=code>
<% rec = 1 %>
<% do until rs.EOF or (rec = 11) %>
</pre id=code>

This is on or about line 211 in forum.asp

Hopefully changing these values won't mess anything up.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

maybe it's better to either add a line which says:
<pre id=code>
rec = mypagesize + 1
</pre id=code>
or just replace rec with the above statement.

Think it's best to only have one constant in the entire code, so you definately only have one place you need to change in order to change the pagesize.

Wanna make the changes animedj?

Blkrogue

In the darkness of my soul a sparkling light has appeared

zecompadre
Junior Member

Portugal
129 Posts

Posted - 09 August 2000 : 04:48:31

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
What all needs to be modified to change the pagesize from 15 to 10 ?

Thanks! <img src=icon_smile.gif border=0 align=middle>

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

i think the page size sould be a option to configure on the main administration of the forum (today is hard coded) !!!

<center>
... REALITY.SYS corrupted. Reboot Universe [Y/N]?
Web Development Foruns
<img src=icon_smile_cool.gif border=0 align=middle> Luis Romão <img src=icon_smile_cool.gif border=0 align=middle>
WEB DEVELOPER
___________________
luis.romao@oninet.pt
Portugal</center>

blkrogue
New Member

USA
79 Posts

Posted - 09 August 2000 : 05:03:48

Just like the hot topics number, right?

Blkrogue

In the darkness of my soul a sparkling light has appeared

slemieux
Junior Member

USA
234 Posts

Posted - 09 August 2000 : 05:22:14

I have been playing with this a bit and Think I have it working correctly. (haven't seen any problems yet)

The way I set it up is users can decide how many posts/topics they see rather than hard coding it or having it as a display option. The paging is set in a cookie or if no cookie is set it defaults to 15.

If you guys could help me test it out at http://209.35.175.12/snitz/default.asp

Of course you'll have to register and some of the old polls will not work correctly because of the way I had it set earlier but should work fine now.

Thanks

blkrogue
New Member

USA
79 Posts

Posted - 09 August 2000 : 06:12:29

After a brief test I can say it works pretty nicely. Love it as it makes your members decide for themselves whether or not they want many pages or just a few with long topics.

Blkrogue

In the darkness of my soul a sparkling light has appeared

slemieux
Junior Member

USA
234 Posts

Posted - 09 August 2000 : 07:06:04

thanks for testing blkrogue!

Just want to clarify this...
The old polls are screwed up regarding paging so they will not work correctly. However any new polls should work just fine.

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 09 August 2000 : 07:44:43

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
What all needs to be modified to change the pagesize from 15 to 10 ?

Thanks! <img src=icon_smile.gif border=0 align=middle>

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

i think the page size sould be a option to configure on the main administration of the forum (today is hard coded) !!!

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

It will be. My code will allow you to set a default for the whole system, then change it for each category and forum. I will have this code out in a little while...

Dave Maxwell
--------------
Self Certified Snitz Bug Swatter <img src=icon_smile_big.gif border=0 align=middle>

marc
Junior Member

Belgium
175 Posts

Posted - 14 August 2000 : 08:55:19

I had to add "dim counter" in paging.asp (sub Pages) and in topics.asp (sub paging).

I had the error :
Microsoft VBScript runtime error '800a01f5'
Illegal assignment: 'Counter'
/forums/topic.asp, line 601

Any idea why I had to do that ?
-marc-

blkrogue
New Member

USA
79 Posts

Posted - 14 August 2000 : 09:11:06

Are you sure you have the inc_functions included in your pages?

I'm not sure but the times I've seen this error come by is 'cause I forgot to include my functions asp-page and therefore the functioncall I made wasn't recognized (well some of us gotta learn da hard way, to figure it out huh <img src=icon_smile_wink.gif border=0 align=middle>)

Maybe that's an answer for having to dim it, but then again, could just have read your question all wrong <img src=icon_smile.gif border=0 align=middle>

Blkrogue

In the darkness of my soul a sparkling light has appeared

animedj
Junior Member

USA
190 Posts

Posted - 14 August 2000 : 10:25:53

I recommend you not use Dim in this case, as the forum still needs to declare variables so error like this won't appear.

marc
Junior Member

Belgium
175 Posts

Posted - 14 August 2000 : 11:44:43

blkrogue, I didn't change the code, so all the original "include" statements should still be there (I didn't check...).

animedj, I don't get what you mean. If I don't put a dim statement in these two procedure, it doesn't work. What else can I do ?!

-marc-

Page: of 3

Topic

Previous Page | Next Page

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.12 seconds.