Jim Lawrence (AccessD)
accessd at shaw.ca
Fri Dec 19 19:35:06 CST 2003
Hi Mark: >Can you insert ASP code into an HTML page that >does not have the .asp extension? In a word, "yes". Below is a very simple example. Given a file named "time.incl" that looks like: <% Response.Write(Time) %> ...then; call the file from a web page: <html> <body> <h3>The time is: <!--#include file="time.incl"--></h3> </body> </html> Now that was easy. See more about it at http://www.w3schools.com/asp/asp_incfiles.asp HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Friday, December 19, 2003 7:39 AM To: '[AccessD]'; '[dba-Tech]' Subject: [AccessD] X-Posted: AccessD / dba-Tech : ASP Quick question... Can you insert ASP code into an HTML page that does not have the .asp extension? I have a requirement in our corporate intranet to maintain our pages using server-side-includes. This means that all pages have a .stm extension. How can I insert the following snippet (many thanks to Drew) into my pages? It works perfectly in my "Test.asp" page but hasn't yet worked on a .stm page. Any suggestions? Mark *** BEGIN CODE *** <% strPageName="Test.asp" dim cnn dim rs dim strSQL dim strPageName dim strIP_Address strIP_Address=request.ServerVariables("REMOTE_ADDR") set cnn=server.createobject("ADODB.Connection") set rs=server.createobject("ADODB.Recordset") cnn.Provider="Microsoft.Jet.OLEDB.4.0" cnn.Open "\\NNSI1\Corp\PROJECTS\E13\WebLog\Statistics.mdb" strSQL="SELECT tblHitCounter.PageName, tblHitCounter.IP_Address FROM tblHitCounter;" rs.Open strSQL,cnn,1,3 rs.AddNew rs.Fields(0).value=strPageName rs.Fields(1).value=strIP_Address rs.Update rs.close set rs=nothing cnn.close set cnn=nothing %> *** END CODE *** _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com