Dump database to html files using ASP?

[dflanagan]

Hello,
The one downfall I have seen with using a database driven ASP site is that it cannot be crawled by the search engine bots, and therefore forces you to PAY for advertising....

I would like to get around that by writing a script that will create HTML versions of my ASP outputs as it looks when a user searches for a product.

Basically I am talking about a script that will loop through my database and for each unigue part number, I would like it to create a new page "partnumber.html" and save it in a certain folder.

I can do the looping and all of that, but what is the function that will give me the HTML, and the ability to save it to disk? Would it be XMLHTTP and FSO? If so, how about a sample??

Thanks!

Dave

 

[mjjks]

Here's sample that read database and creates html elements(links from database).

You need to convert your html page's head/footer into strings, create html page in ASP, insert header string, dynamic part from database, footer strring and move to next page

http://www.tek-tips.com/viewthread.cfm?qid=1135983&page=4

 

[damber]

The one downfall I have seen with using a database driven ASP site is that it cannot be crawled by the search engine bots, and therefore forces you to PAY for advertising....

You might want to check that assumption - the SEO forum (forum828) will help you understand this further.

A smile is worth a thousand kind words. So smile, it's easy!

 

[dflanagan]

All,
i have resolved the issue brought up on this thread through another thread title xmlhttp

Now I am looking into this SEO thread you showed me... My understanding was that Yahoo, google, and MSN (the big ones) do not crawl database sites, and in fact ignore all urls that contain question marks.

I guess this is a post better meant for that forum though

Dave

 

[damber]

Just run a google search and look at the result urls, for example:

http://www.google.com/search?hs=Tsr...l&q=asp+forum+tek+tips+inurl:?id=&btnG=Search

All these have '?' in the url..

A smile is worth a thousand kind words. So smile, it's easy!