Running a stored ASP code. Is it possible?

Hello,

I have created a site based on one ASP which is reading the pages, including
VB and JS code from an ACCESS db, and it is working fine.

Can I store an ASP code that will be executed on the server side in that db?
And if yes, how?
i.e.
The steps I have in mind are:
My asp page is accessing the “site” db , reading the asp code, executing it.

Thanks
Rami

Re: Running a stored ASP code. Is it possible?

There is Eval and Execute that you can use. IE:

sCommand = "Response.Write ""Hi there"""
Execute sCommand

I can't imagine why you have things setup the way you describe though!

Ray at work

"Rami" wrote in message
news:F10EE605-D2E6-4932-ACAD-B067F6E4F555@microsoft.com...
> Hello,
>
> I have created a site based on one ASP which is reading the pages,
> including
> VB and JS code from an ACCESS db, and it is working fine.
>
> Can I store an ASP code that will be executed on the server side in that
> db?
> And if yes, how?
> i.e.
> The steps I have in mind are:
> My asp page is accessing the "site" db , reading the asp code, executing
> it.
>
> Thanks
> Rami
>

Re: Running a stored ASP code. Is it possible?

On Wed, 8 Sep 2004 11:47:15 -0700, "Rami"
wrote:

>Hello,
>
>I have created a site based on one ASP which is reading the pages, including
>VB and JS code from an ACCESS db, and it is working fine.
>
>Can I store an ASP code that will be executed on the server side in that db?
>And if yes, how?
>i.e.
>The steps I have in mind are:
>My asp page is accessing the “site” db , reading the asp code, executing it.

No. The page is processed by the ASP.DLL, which accesses the
database. The database has ASP code, which can't be processed since
the page was already processed.

You need to use one ASP page to dynamically build the second from code
in the database, then execute the new page. A Server.Transfer might
help, but I suspect this will be a lot more trouble for you than
whatever issue you think you're trying to resolve.

Jeff

Re: Running a stored ASP code. Is it possible?

You might consider using server side includes instead of pulling all of
your hair out in frustration from that method.

Rami wrote:

> Hello,
>
> I have created a site based on one ASP which is reading the pages, including
> VB and JS code from an ACCESS db, and it is working fine.
>
> Can I store an ASP code that will be executed on the server side in that db?
> And if yes, how?
> i.e.
> The steps I have in mind are:
> My asp page is accessing the “site” db , reading the asp code, executing it.
>
> Thanks
> Rami
>

Re: Running a stored ASP code. Is it possible?

If it hasn't been asked - What is the business objective that you're
trying to accomplish?

Rami wrote:
> Hello,
>
> I have created a site based on one ASP which is reading the pages, including
> VB and JS code from an ACCESS db, and it is working fine.
>
> Can I store an ASP code that will be executed on the server side in that db?
> And if yes, how?
> i.e.
> The steps I have in mind are:
> My asp page is accessing the “site” db , reading the asp code, executing it.
>
> Thanks
> Rami
>

Re: Running a stored ASP code. Is it possible?

Hi,
It has been a while since you you wrote me your answere but I just wanted to
let you know I’m using execute and it is doing the job for me.

As to way do it,

My stored it db site should have a standard look at all pages , which is
changing according to the month.
Some of the pages should use a dynamic data stored in another database.
If I was writing an asp page to access these pages, I will have to modify
them every time.
It was some work to write the right code that will be executed, but the way
it is now, I don’t have to do anything, so I’m happy …
Thanks
Rami



"Ray Costanzo [MVP]" wrote:

> There is Eval and Execute that you can use. IE:
>
> sCommand = "Response.Write ""Hi there"""
> Execute sCommand
>
> I can't imagine why you have things setup the way you describe though!
>
> Ray at work
>
> "Rami" wrote in message
> news:F10EE605-D2E6-4932-ACAD-B067F6E4F555@microsoft.com...
> > Hello,
> >
> > I have created a site based on one ASP which is reading the pages,
> > including
> > VB and JS code from an ACCESS db, and it is working fine.
> >
> > Can I store an ASP code that will be executed on the server side in that
> > db?
> > And if yes, how?
> > i.e.
> > The steps I have in mind are:
> > My asp page is accessing the "site" db , reading the asp code, executing
> > it.
> >
> > Thanks
> > Rami
> >
>
>
>

Re: Running a stored ASP code. Is it possible?

Hi,
It has been a while, but you might be interested it what I did, according to
Ray’s suggestion.


"joker" wrote:

> You might consider using server side includes instead of pulling all of
> your hair out in frustration from that method.
>
> Rami wrote:
>
> > Hello,
> >
> > I have created a site based on one ASP which is reading the pages, including
> > VB and JS code from an ACCESS db, and it is working fine.
> >
> > Can I store an ASP code that will be executed on the server side in that db?
> > And if yes, how?
> > i.e.
> > The steps I have in mind are:
> > My asp page is accessing the “site” db , reading the asp code, executing it.
> >
> > Thanks
> > Rami
> >
>
>

Re: Running a stored ASP code. Is it possible?

Hi,
It has been a while, but you might be interested it what I did, according to
Ray’s suggestion.


"Jeff Cochran" wrote:

> On Wed, 8 Sep 2004 11:47:15 -0700, "Rami"
> wrote:
>
> >Hello,
> >
> >I have created a site based on one ASP which is reading the pages, including
> >VB and JS code from an ACCESS db, and it is working fine.
> >
> >Can I store an ASP code that will be executed on the server side in that db?
> >And if yes, how?
> >i.e.
> >The steps I have in mind are:
> >My asp page is accessing the “site” db , reading the asp code, executing it.
>
> No. The page is processed by the ASP.DLL, which accesses the
> database. The database has ASP code, which can't be processed since
> the page was already processed.
>
> You need to use one ASP page to dynamically build the second from code
> in the database, then execute the new page. A Server.Transfer might
> help, but I suspect this will be a lot more trouble for you than
> whatever issue you think you're trying to resolve.
>
> Jeff
>

Re: Running a stored ASP code. Is it possible?

Hi,
It has been a while, but you might be interested it what I did, according to
Ray’s suggestion.


"David C. Holley" wrote:

> If it hasn't been asked - What is the business objective that you're
> trying to accomplish?
>
> Rami wrote:
> > Hello,
> >
> > I have created a site based on one ASP which is reading the pages, including
> > VB and JS code from an ACCESS db, and it is working fine.
> >
> > Can I store an ASP code that will be executed on the server side in that db?
> > And if yes, how?
> > i.e.
> > The steps I have in mind are:
> > My asp page is accessing the “site” db , reading the asp code, executing it.
> >
> > Thanks
> > Rami
> >
>