https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 18:25:40 +0000 Wed, 09 May 2007 19:01:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23281 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122634.html#122634 Author: WebWiz-Bruce
Subject: 23281
Posted: 09 May 2007 at 7:01pm

Only performance wize if on a slow network or using Access]]> Wed, 09 May 2007 19:01:24 +0000 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122634.html#122634 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122631.html#122631 Author: kiklop
Subject: 23281
Posted: 09 May 2007 at 5:26pm

Thanks boRg; is there any drawback for doing this?]]> Wed, 09 May 2007 17:26:29 +0000 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122631.html#122631 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122629.html#122629 Author: WebWiz-Bruce
Subject: 23281
Posted: 09 May 2007 at 5:15pm

Yes you would need to change the const to a dim if you want to dynamically assign a value to it.]]> Wed, 09 May 2007 17:15:01 +0000 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122629.html#122629 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122624.html#122624 Author: kiklop
Subject: 23281
Posted: 09 May 2007 at 4:25pm

I'm curious about declaring the intMaxResults value and hope someone can help me a bit here.

I use the default intMaxResults value of 500 for all my (sub)forums. However, we do have one subforum that i would like to increase this limit, but since i don't want to compromise the whole forum performance i wonder what's the best way of doing it.

Since intMaxResults is constant i can't use something like

If intForumID=X then
intMaxResults=xxx
Else
intMaxResults=xx
End if.

But if i change

Cont intMaxResults=500
to something like

Dim intMaxResults
intMaxResults= 500 i can use If statement which does work. Now the question is; can i change "Const" declaration to dim intMaxResults without causing any problem?

Thank you ! ]]> Wed, 09 May 2007 16:25:15 +0000 https://forums.webwiz.net/question-about-intmaxresults-variable_topic23281_post122624.html#122624