Try the following test page:
<html>
<head>
<title>Test Page</title>
<!--#INCLUDE FILE="..\forum\config.asp" -->
</head>
<body>
<%
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
strSql ="SELECT " & strTablePrefix & "TOTALS.U_COUNT "
strSql = strSql & " FROM " & strTablePrefix & "TOTALS "
set rs = my_Conn.execute(strSql)
TotalUsers = rs("U_COUNT")
Response.write("There are Currently " & " " & TotalUsers & " " & " members.")
%>
</body>
</html>
Note that the INCLUDE FILE statement is set in this page to be in one directory off the root, but other than the forum directly (which is also off the root). You may have to change this statement to accomadate where your page is located on your site. For instance, if your page resides in your root directory and your forum directory is one directory off the root directory, then the statement would change to:
<!--#INCLUDE FILE="forum\config.asp" -->
Also note, that it must be inside a asp file, not a html file. Create a file titled "test.asp" and post the code above in it.
-
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/*
Edited by - James on 06 May 2002 23:01:02