ASP Code not interpreted

[George Kentman]

Hi there,

I am storing asp code as content in a table field (MS SQL Server).
When I try to display it via a HTML page only the HTML is interpreted,
but not the asp code.
What is the problem?

Regards

[John]

Please give some exemples of the content of the record and the asp code to
show.

[Aaron [SQL Server MVP]]

ASP only runs once. You can't store ASP code in the database, retrieve it
using ASP, and then expect it to run.

Can you give a better description of exactly what you are trying to
accomplish? What ASP code is in the database, and what do you expect to
happen?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"George Kentman" <Kentman@gmx.de> wrote in message
news:cf1f7203.0407210204.4a0536f3@posting.google.c om...

> Hi there,
>
> I am storing asp code as content in a table field (MS SQL Server).
> When I try to display it via a HTML page only the HTML is interpreted,
> but not the asp code.
> What is the problem?
>
> Regards

[Jeff Cochran]

On 21 Jul 2004 03:04:01 -0700, [email]Kentman@gmx.de[/email] (George Kentman) wrote:

>I am storing asp code as content in a table field (MS SQL Server).
>When I try to display it via a HTML page only the HTML is interpreted,
>but not the asp code.
>What is the problem?

Probably what you're attempting to do with it. If the ASP is content
in the database and you're retrieving that content in an ASP page, the
ASP has already been processed by the time the content is sent to the
browser. Since ASP has to be processed by the server, sending it to
the browser as content from a database won't work.

Perhaps if you went into detail on what it was, how you wanted to use
it and why, we could suggest a wrokable alternative.

Jeff

[George Kentman]

[email]Kentman@gmx.de[/email] (George Kentman) wrote in message news:<cf1f7203.0407210204.4a0536f3@posting.google. com>...

> Hi there,
>
> I am storing asp code as content in a table field (MS SQL Server).
> When I try to display it via a HTML page only the HTML is interpreted,
> but not the asp code.
> What is the problem?
>
> Regards

It's like most of you guessed ;)
I am storing ASP Code which may contain Code for the execution of
SQL-Statements e.g. retrieving client data from the database and I
want that information to be displayed on HTML pages. The reason why I
am storing the code as content is the cms application that stands
behind it and is responsible for the HTML design.

Greetings

[Aaron [SQL Server MVP]]

> I am storing ASP Code which may contain Code for the execution of

> SQL-Statements e.g. retrieving client data from the database

Why not store JUST the SQL statements? Then you can pull them from the
database like this:

set rs = conn.execute("SELECT sqlStatement FROM sometable WHERE ... ")
newSQL = rs(0)
set rs = conn.execute(newSQL)
do while not rs.eof
...
rs.movenext
loop

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

[Jeff Cochran]

On 22 Jul 2004 01:28:28 -0700, [email]Kentman@gmx.de[/email] (George Kentman) wrote:

>Kentman@gmx.de (George Kentman) wrote in message news:<cf1f7203.0407210204.4a0536f3@posting.google. com>...

>> Hi there,
>>
>> I am storing asp code as content in a table field (MS SQL Server).
>> When I try to display it via a HTML page only the HTML is interpreted,
>> but not the asp code.
>> What is the problem?
>>
>> Regards

>
>It's like most of you guessed ;)
>I am storing ASP Code which may contain Code for the execution of
>SQL-Statements e.g. retrieving client data from the database and I
>want that information to be displayed on HTML pages. The reason why I
>am storing the code as content is the cms application that stands
>behind it and is responsible for the HTML design.

You'll likely need to split your pages then, the first request is for
the info to build the real page, with a Server.Transfer to call that
second page. If you don't need the ASP you could store the SQL
queries and call them from the database as part of your query.

Jeff