Use a Variable for an Include Statement

ptetz · August 25th, 2003, 03:15 PM

Hi there,

I'm trying to create a website that is completely database driven (Access) using VBScript. I want to use a variable for my include file statement, but when I pull the text from the database:
(data stored in Access)

In my default file, I use the variable:
<% =txt_header %>

all that ends up on the screen is the text from the database (as shown above) versus the code from the header.asp include file (i.e. logo, etc.) It doesn't seem to process the include file directive, only the request from the database. There must be a step I'm missing, but I'm not sure what it is.

I also use a different include file (tblpages.asp) in the default page to extract the database information into variables before I use the variable.

Does this make sense to anybody, and would somebody know how to work around this?

Sample code of my default.asp page:

(extract variables)

<html>
<head>
    <title><%= txt_Title %></title>
    <meta name=Keywords content="<%= txt_Keywords %>">
    <meta name=Description content="<%= mem_Description %>">
    <link rel="stylesheet" href="<%= txt_Stylesheet %>" type="text/css">
</head>
<body>
<table width="760" height="100%" border=0 cellspacing=3 cellpadding=3>

  <tr valign="top">

        <td colspan=2>
            <% =txt_Header %>(all other variables work, except this one)
        </td>
  </tr>

Thanks!

Paula

Imar · August 25th, 2003, 03:51 PM

Hi Paula,

Dynamic includes won't work like that. ASP pages are included before the page is executed, so the variables don't have a value yet.

Check out this article for a more thorough explanation and some work arounds.

HtH

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

kilika · August 25th, 2003, 03:52 PM

The include statements are evaluated and included before any ASP code is executed. Unfortunately, you cannot dynamically generate include file statements

Chris