|
 |
asp_databases thread: include file vs include virtual
Message #1 by fione0212@h... on Tue, 31 Jul 2001 17:24:15
|
|
Dear users:
Does anyone know the differences between a include file vs include virtual
in HTML? I'm looking all over for an answer for the include virtual, I
didn't find any answer for that. Thanks!!
Vicky
Message #2 by "Hasenfratz, Philipp" <maillist@e...> on Tue, 31 Jul 2001 19:04:03 +0200
|
|
> Does anyone know the differences between a include file vs include virtual
> in HTML? I'm looking all over for an answer for the include virtual, I
> didn't find any answer for that. Thanks!!
>
> Vicky
Hello Vicky,
include file : the path is "translated" regarding the physical drive
directory structure
include virtual : the path is "translated" regarding the directory structure
of the WebServer.
for example : <!--#include virtual="/api/goto.asp"--> : includes the file :
/<Web-Server>/<Document-root>/api/goto.asp
<!--#include file="/api/goto.asp"--> : includes the file :
<root-directory>/api/goto.asp (where root-directory is "c:" f. ex.)
Just to say : You can't include files in HTML, you probably mean .ASP or SSI
(Server Side Includes)
regards
---Philipp
Message #3 by "Fione Ho" <fione0212@h...> on Tue, 31 Jul 2001 14:50:28 -0700
|
|
Thanks Phillip, you are great!!
By the way I have another problem that I like you to resolve
here is the error
Provider error '80040e55'
Column does not exist.
/orgchart1/EditEmp_HND.asp, line 49
And here is the editEmp_HND.asp file
<%Option Explicit%>
<!-- #include file="adovbs.inc" -->
<!-- #include file="ADOFunctions_inc.asp" -->
<HTML>
<HEAD>
<TITLE>Update Employee Details </title>
</HEAD>
<BODY>
<LINK rel="stylesheet" type="text/css" href="orgchart1.css">
<CENTER><H2>Update Employee Details </h2></center>
<%
Dim objCommand
Dim varEmpno
Dim varEname_last
Dim varEname_first
Dim varPhone
Dim varLocation
Dim varTitle
Dim varExpertise
Dim varJob_Description
With Request
varEmpno = .QueryString("empno")
varEname_last = .Form("varEname_last")
varEname_first = .Form("varEname_first")
varPhone = .Form("varPhone")
varLocation = .Form("varLocation")
varTitle = .Form("varTitle")
varExpertise = .Form("varExpertise")
varJob_Description = .Form("varJob_Description")
End with
set objCommand = Server.CreateObject("ADODB.Command")
set objCommand.ActiveConnection = GetDBConnection()
If varEmpno <> 0 Then
With objCommand
.CommandText = "{call emp_UPDATE(?, ?, ?, ?, ?, ?, ?)}"
.CommandType = adCmdText
.Parameters(0).Value = varEmpno
.Parameters(1).Value = varEname_last
.Parameters(2).Value = varEname_first
.Parameters(3).Value = varPhone
.Parameters(4).Value = varLocation
.Parameters(5).Value = varTitle
.Parameters(6).Value = varExpertise
.Parameters(7).Value = varJob_Description
.Execute()
Response.Write "Record for employee" & varEmpno & "has been updated."
End With
else
With objCommand
.CommandText = "{call EMP_ADD(?, ?, ?, ?, ?, ?, ?)}"
.CommandType = adCmdText
.Parameters(0).Value = varEmpno
.Parameters(1).Value = varEname_last
.Parameters(2).Value = varEname_first
.Parameters(3).Value = varPhone
.Parameters(4).Value = varLocation
.Parameters(5).Value = varTitle
.Parameters(6).Value = varExpertise
.Parameters(7).Value = varJob_Description
.Execute()
Response.Write "Record for employee " & varEmpno & "has been added."
End With
End if
set objCommand = nothing
%>
<P>
<A href = "default.asp">Home </A>
</BODY>
</HTML>
thanks
>From: "Hasenfratz, Philipp" <maillist@e...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: include file vs include virtual
>Date: Tue, 31 Jul 2001 19:04:03 +0200
>
> > Does anyone know the differences between a include file vs include
>virtual
> > in HTML? I'm looking all over for an answer for the include virtual, I
> > didn't find any answer for that. Thanks!!
> >
> > Vicky
>
>Hello Vicky,
>
>include file : the path is "translated" regarding the physical drive
>directory structure
>
>include virtual : the path is "translated" regarding the directory
>structure
>of the WebServer.
>
>for example : <!--#include virtual="/api/goto.asp"--> : includes the file :
>/<Web-Server>/<Document-root>/api/goto.asp
> <!--#include file="/api/goto.asp"--> : includes the file :
><root-directory>/api/goto.asp (where root-directory is "c:" f. ex.)
>
>Just to say : You can't include files in HTML, you probably mean .ASP or
>SSI
>(Server Side Includes)
>
>regards
>
>---Philipp
>
|
|
|
View Cart
