Web Wiz Forums - question: Common.asp in new

Print Page | Close Window

question: Common.asp in new_page and DB connection

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18661
Printed Date: 13 April 2026 at 5:14am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: question: Common.asp in new_page and DB connection

Posted By: miladanimator
Subject: question: Common.asp in new_page and DB connection
Date Posted: 09 March 2006 at 6:14pm

I Need To Design A New_Page.asp in mysite/forum folder that contain :



And Now I have a question :
when I include the common.asp in a new .asp page , should I insert this code to close the Database Connection ?

<%
'Release server objects
Set rsCommon = Nothing
adoCon.Close
Set adoCon = Nothing
%>

And where I should insert this code ? End of the page or ... ???

Excuse me for my bad English grammer ...

Replies:

Posted By: WebWiz-Bruce
Date Posted: 10 March 2006 at 1:27pm

If you include the 'common.asp' file you will need to close the database connection.

I'm currently working on modulising the code in version 8 so that you call openDatabase() to open the database and closeDatabase() to close it.

This should make it simpler for moders and for those wanting to use forum data in other parts of their sites for 'last 10 posts' or membership integration.