Get File Includes To Execute Correctly - I want to store a #include in a db field and have that include or code execute on an .asp page

I am trying to build a content management system for an existing site, but so much of the content is in both massive amounts of includes or free form code.  I want/need to find a way to store code like the following:

            <td valign="top"><!--#include file="../crf/includes/sitemenu_black.asp"--></td>

 in a database field (MS Access) and have that stored field value execute as if I typed the code in myself.

The database does not have an issue with storing and string of code you give it, but I do not know how to get more than the HTML to execute correctly on a dynamic page...the #include does not work if I do something like <% Response.Write(objRSName("FieldName")%> or <%=objRSName("FieldName") %>, as the server attempts to write the <!--#include file="../crf/includes/sitemenu_black.asp"--> as text on the page but it renders the normal HTML code correctly.

This is extremely urgent.

Who is Participating?
alorentzConnect With a Mentor Commented:
INCLUDE files are executed BEFORE any you cannot do what you are trying to do...because the script happens after the include files are processed (hence why it is rendered as text.)

What you are trying to do is to call the includes when you need them. However, ASP doesn't support conditional includes. You can not add INCLUDES within IFs or FORs. Read here:
I suggest you include all of the files, but modify them so the code appears inside SUBs. Than call the SUBs on those occasions. This way, all the code is included to all pages, but only the necessary parts are run.
@huji - for the most part correct, as I mentioned.  However:

>>You can not add INCLUDES within IFs or FORs

This is not correct.  Includes can be included within IF or FOR, and are executed conditionally based on the IF or FOR.

For example:


if request("test") = "1" then
<!--#include file="/includes/test1.asp"-->
<!--#include file="/includes/test2.asp"-->
end if

This is perfectly fine.  While both includes are processed before the script, only one is actually included in the rendered result.  Same for using in a FOR loop.
I meant the same thing indeed. The link I posted mentions an example of including within FOR. However, now that I read it, what I've written has a different meaning, which is totally wrong.
Thanks for your notification. It really worths a lot.
All Courses

From novice to tech pro — start learning today.