HTML generation

[yorks]

Hi all

does anyone know of any code which will do the following.

Say we have a product display page which displays database from a database about a product. ie.

show_product.asp?prodid=773

I want to go through all products in the database and generate a static HTML page for each rather than using ASP to generate the page on the fly

Thanks

[mikesmith76]

why???

[yorks]

Hi

Because in the application we have, these pages (not product pages, I used that as an example) are not updated that often but do need to be updatable at anytime by users.

If we can store them as a HTML page when they change, it will save thousands of database accesses

[Faglork]

Don't know which CMS / eCommerce prog you use, but many of them have a configurable cache - this might suffice.

Apart from that, I am not quite sure what you are asking for - there is no information about the CMS you use. How do you update? Via online form? Then you could modify the program to write an HTML file after clicking the OK button. Or do you upload an updated database? If so, do you update on a regular time schedule or as needed? There are multiple solutions, but without any real info it is hard to suggest anything.

faglork

[yorks]

hi faglork

i'll try and explain..

the user updates their profile information via a form. This is then written to the database (MSSQL).

Other users can look at this profile information which obviously requires a database query to retrieve the data and therefore display it.

What I require is to be able to write an .htm page of the users profile whenever its updated then no database accesses would be required to view that profile.

thanks

[mikesmith76]

Just reread your original post, you should start by looking up file access in ASP. It's been a while since I have used it but there should be plenty of resources available. The easiest way would be to create a html template file. When somebody updates their profile you can read in this template, replace some markers and then save the changed version.

The major problem I can think of with this solution is managing the links to the static pages, best bet may be to use the userid of the person as the profile page name.