|
 |
asp_databases thread: RE: Convert asp to static html
Message #1 by Jason Greenfeld-Unitek <jason.greenfeld@u...> on Mon, 1 Apr 2002 16:52:23 -0500
|
|
Well, lets break this down a bit....
First you need to get the data from your database. I suppose you will want
to use a recordset to achieve this.
Then you want to create an htm file with the data you have in your
recordset.
So, create your FileSystemObject
ex: set objFso = Server.CreateObject("Scripting.FileSystemObject")
There is this cool little thingy callen Intellisense, and it allows you to
LEARN different methods and properties of an object.
In FSO, there is a property that allows you to CREATE A FILE or Text
Stream...
ex: objStream = objFso.CreateTextFile(filename, overwrite, unicode)
Then you could use a loop to write your data to this file
After you are done creating your htm file... Then re-direct your user to
your newly created file.
EX: Response.Redirect(filename)
btw, they write these wonderful books that allow you to learn ASP, and FSO
is covered in them. All of this information could be gathered from Wrox's
"Active Server Pages 3.0 Professional"
Also there a TON of web sites that you can REFERENCE. These sites will help
you LEARN how to solve your problems.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 2:50 PM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
Yes, but how would I go about doing just that?
> Correction:
FSO = File Scripting Object.... Not File Scription Object...
Damn fat fingers!!!
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Jason Greenfeld-Unitek [mailto:jason.greenfeld@u...]
Sent: Monday, April 01, 2002 11:27 AM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
If your initial asp page, get the data from the database, then use FSO
(File
Scription Object) to create a .htm file on the server. After all objects
and
connections are closed, re-direct the user to the newly created htm page.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 11:13 AM
To: ASP Databases
Subject: [asp_databases] Convert asp to static html
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
Message #2 by "Niraj Sharma" <nsharma@y...> on Mon, 1 Apr 2002 19:50:29
|
|
Yes, but how would I go about doing just that?
> Correction:
FSO = File Scripting Object.... Not File Scription Object...
Damn fat fingers!!!
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Jason Greenfeld-Unitek [mailto:jason.greenfeld@u...]
Sent: Monday, April 01, 2002 11:27 AM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
If your initial asp page, get the data from the database, then use FSO
(File
Scription Object) to create a .htm file on the server. After all objects
and
connections are closed, re-direct the user to the newly created htm page.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 11:13 AM
To: ASP Databases
Subject: [asp_databases] Convert asp to static html
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
Message #3 by Jason Greenfeld-Unitek <jason.greenfeld@u...> on Mon, 1 Apr 2002 11:46:13 -0500
|
|
Correction Again:
FSO = File System Object.... not File Scripting Object....
You can create that by calling:
Set variable = Server.CreateObject("Scripting.FileSystemObject")
Sorry for the confusion Niraj
I need to get it together today!
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Jason Greenfeld-Unitek [mailto:jason.greenfeld@u...]
Sent: Monday, April 01, 2002 11:33 AM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
Correction:
FSO = File Scripting Object.... Not File Scription Object...
Damn fat fingers!!!
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Jason Greenfeld-Unitek [mailto:jason.greenfeld@u...]
Sent: Monday, April 01, 2002 11:27 AM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
If your initial asp page, get the data from the database, then use FSO (File
Scription Object) to create a .htm file on the server. After all objects and
connections are closed, re-direct the user to the newly created htm page.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 11:13 AM
To: ASP Databases
Subject: [asp_databases] Convert asp to static html
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
Message #4 by Jason Greenfeld-Unitek <jason.greenfeld@u...> on Mon, 1 Apr 2002 11:26:43 -0500
|
|
If your initial asp page, get the data from the database, then use FSO (File
Scription Object) to create a .htm file on the server. After all objects and
connections are closed, re-direct the user to the newly created htm page.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 11:13 AM
To: ASP Databases
Subject: [asp_databases] Convert asp to static html
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
Message #5 by Jason Greenfeld-Unitek <jason.greenfeld@u...> on Mon, 1 Apr 2002 11:33:10 -0500
|
|
Correction:
FSO = File Scripting Object.... Not File Scription Object...
Damn fat fingers!!!
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Jason Greenfeld-Unitek [mailto:jason.greenfeld@u...]
Sent: Monday, April 01, 2002 11:27 AM
To: ASP Databases
Subject: [asp_databases] RE: Convert asp to static html
If your initial asp page, get the data from the database, then use FSO (File
Scription Object) to create a .htm file on the server. After all objects and
connections are closed, re-direct the user to the newly created htm page.
----------------------------------------------------
Jason A. Greenfeld
Lead Software Developer
Unitek Technical Services
-----Original Message-----
From: Niraj Sharma [mailto:nsharma@y...]
Sent: Monday, April 01, 2002 11:13 AM
To: ASP Databases
Subject: [asp_databases] Convert asp to static html
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
Message #6 by "Niraj Sharma" <nsharma@y...> on Mon, 1 Apr 2002 16:39:05
|
|
I mean a dynamic conversion of the .asp to a .htm file sitting on the
server!
> View the ASP page with IE, then do View > Source. Then save the source
as a .htm file.
-Pete
> -----Original Message-----
> From: Niraj Sharma [mailto:nsharma@y...]
> Sent: Monday, April 01, 2002 4:13 PM
> To: ASP Databases
> Subject: [asp_databases] Convert asp to static html
>
>
>
> I have an .asp page which retrieves a long list of items from
> sql server.
> I would like to create a static .htm version of the dynamic
> data for this
> page.
>
> How can I do this?
>
Message #7 by "Peter Foti (PeterF)" <PeterF@S...> on Mon, 1 Apr 2002 10:21:37 -0500
|
|
View the ASP page with IE, then do View > Source. Then save the source
as a .htm file.
-Pete
> -----Original Message-----
> From: Niraj Sharma [mailto:nsharma@y...]
> Sent: Monday, April 01, 2002 4:13 PM
> To: ASP Databases
> Subject: [asp_databases] Convert asp to static html
>
>
>
> I have an .asp page which retrieves a long list of items from
> sql server.
> I would like to create a static .htm version of the dynamic
> data for this
> page.
>
> How can I do this?
>
Message #8 by "Niraj Sharma" <nsharma@y...> on Mon, 1 Apr 2002 16:12:50
|
|
I have an .asp page which retrieves a long list of items from sql server.
I would like to create a static .htm version of the dynamic data for this
page.
How can I do this?
|
|
|
View Cart
