By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,116 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,116 IT Pros & Developers. It's quick & easy.

database >> html file via FSO?

P: n/a
I would appreciate some help on how to convert a database table into an html
file via FSO and whether more seasoned asp programmers recommned this route.
The main reason I am attempting to do this is becuase we are constantly
being told by so-called marketing gurus that 'html' pages are more search
engine friendly.

Other advantages include speed of download.

Will there be any problems with using this approach besides establishing
permissions on our remote web host....is it possible that the updated
html-from-fso file will get 'locked' as you attempt to update it via the
database...are there problems with caching....I would appreciate some
pointers on the curve balls associated with this method.

Here is a typical portion of the database table I wish to smash into html...
Latest mulihulls added to our site!
Model Size Name Condition Original Price Reduced
Price
Lagoon 23 X -factor Used 200000 100000
Privilege 45 ASDF Used 30000 28000

Appreciate advice
Jason
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi...

- Access 2000

- FSO seems like the only possiblity to dynamically constrcut html pages on
the fly from a the database and asp with an .htm rather than .asp extension

- More friendly than .ASP pages which require round trips to the server and
take longer to proces than vaniall .htm files

- The database is sitting online at our remote web host. At first we will
ftp overwrite the database but will improve the admin by allowing asp-admin
pages. to construct the asp pages - and hopefully - an html version....

The database will be used for displaying data to the website visitor and to
generate backend reports. I am only interested in generating an html page
for the menu section of our new yacht listings

Thanks
Jason
"William Tasso" <ng*@tbdata.com> wrote in message
news:uW**************@tk2msftngp13.phx.gbl...
jason wrote:
I would appreciate some help on how to convert a database table into
an html file via FSO and whether more seasoned asp programmers
recommned this route.
What brand of database? Why go via fso?
The main reason I am attempting to do this is
becuase we are constantly being told by so-called marketing gurus
that 'html' pages are more search engine friendly.


than what?
Other advantages include speed of download.


possibly
Will there be any problems with using this approach besides
establishing permissions on our remote web host....is it possible
that the updated html-from-fso file will get 'locked' as you attempt
to update it via the database...are there problems with caching....I
would appreciate some pointers on the curve balls associated with
this method.


are you trying to maintain your database on the server or upload a file

for display/reporting only?
--
William Tasso - http://WilliamTasso.com

Jul 19 '05 #2

P: n/a
Gazing into my crystal ball I observed "jason" <ja***@catamaranco.com>
writing in news:#O**************@TK2MSFTNGP10.phx.gbl:
"William Tasso" <ng*@tbdata.com> wrote in message
news:uW**************@tk2msftngp13.phx.gbl...
jason wrote:
> I would appreciate some help on how to convert a database table into
> an html file via FSO and whether more seasoned asp programmers
> recommned this route.
What brand of database? Why go via fso?
> The main reason I am attempting to do this is
> becuase we are constantly being told by so-called marketing gurus
> that 'html' pages are more search engine friendly.


than what?
> Other advantages include speed of download.


possibly
> Will there be any problems with using this approach besides
> establishing permissions on our remote web host....is it possible
> that the updated html-from-fso file will get 'locked' as you attempt
> to update it via the database...are there problems with caching....I
> would appreciate some pointers on the curve balls associated with
> this method.


are you trying to maintain your database on the server or upload a
file for display/reporting only?

Hi...

- Access 2000

- FSO seems like the only possiblity to dynamically constrcut html
pages on the fly from a the database and asp with an .htm rather than
.asp extension

- More friendly than .ASP pages which require round trips to the server
and take longer to proces than vaniall .htm files

- The database is sitting online at our remote web host. At first we
will ftp overwrite the database but will improve the admin by allowing
asp-admin pages. to construct the asp pages - and hopefully - an html
version....


Personally, I think you're trying to solve the wrong problem. ASP pages,
if marked up correctly, are just as search engine friendly as regular HTML
pages. After all, the search engine/person only sees the HTML that is
generated by the ASP script.

HTML pages, as you know, are static, so they would have to be regenerated
every time there was a change to the table. Are you going to remember to
do this?

The database will be used for displaying data to the website visitor
and to generate backend reports. I am only interested in generating an
html page for the menu section of our new yacht listings


You're not thinking of using Frames, are you? I hope not.
--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com
Jul 19 '05 #3

P: n/a
jason wrote:

"William Tasso" <ng*@tbdata.com> wrote in message
news:uW**************@tk2msftngp13.phx.gbl...
jason wrote:
I would appreciate some help on how to convert a database table into
an html file via FSO and whether more seasoned asp programmers
recommned this route.
What brand of database? Why go via fso?
The main reason I am attempting to do this is
becuase we are constantly being told by so-called marketing gurus
that 'html' pages are more search engine friendly.


than what?
Other advantages include speed of download.


possibly
Will there be any problems with using this approach besides
establishing permissions on our remote web host....is it possible
that the updated html-from-fso file will get 'locked' as you attempt
to update it via the database...are there problems with caching....I
would appreciate some pointers on the curve balls associated with
this method.


are you trying to maintain your database on the server or upload a
file for display/reporting only?

- Access 2000

- FSO seems like the only possiblity to dynamically constrcut html
pages on the fly from a the database and asp with an .htm rather than
.asp extension


ok - that would work. reading the mdb and writing your .html files through
FSO
- More friendly than .ASP pages which require round trips to the
server and take longer to proces than vaniall .htm files
I'm afraid your "so-called marketing gurus" have been fed a crumb and are
turning it into a feast. There are no more trips to the server with asp vs
html. yes, the server will take longer to process asp but unless we are
talking about extreme processing the two biggest factors affecting speed
will be bandwidth and ms-access; the third is the rendering capabilities of
the browser. You can use the free sample at http://netmechanic.com to check
how your pages are performing. Assuming you have been prompted by a
performance issue and your server is operating within its capabilities, I'll
wager that the mdb is your bottle-neck and an upgrade to SQL-Server will
produce the required performance and be far less intensive on development
resources.

- The database is sitting online at our remote web host. At first we
will ftp overwrite the database but will improve the admin by
allowing asp-admin pages. to construct the asp pages - and hopefully
- an html version....


This is going to be a maintenance nightmare, but if your marketing bods
insist then let me suggest you research off-line pre-processors instead of
re-inventing the wheel.
--
William Tasso - http://WilliamTasso.com
Jul 19 '05 #4

P: n/a
>I would appreciate some help on how to convert a
database table into an html file via FSO and whether
more seasoned asp programmers recommned this route.
There is help on using FSO here;

http://www.aspfaq.com/show.asp?id=2039

The main reason I am attempting to do this is becuase
we are constantly being told by so-called marketing
gurus that 'html' pages are more search engine friendly.
And if you told them how to do their job what would they
say?

They only real way that html is more search-engine
friendly is when your ASP page works something like;

product.asp?ID=123

ie you only have one page but different params that show
the different products. If there is no list of links to
all your products somewhere then search spiders can't see
all variations of your products. However the same will go
if you convert them all to htm, you will still need a link
to each product somewhere so that the spiders and trawl
your site correctly.

If you are talking about Index Server to search your own
site, however, then they do have a point.
Other advantages include speed of download.
If you are using IIS5 then the performance is better than
IIS4 as pages are cached, but html will always be a
nanosecond or two faster then asp.
Will there be any problems with using this approach
besides establishing permissions on our remote web
host....


As has been said it is a maintenance nightmare. You will
need to schedule some process somewhere that re-generates
all the static pages when your database changes, or
something that keeps track of what tables have been
altered and genereates new html as required.

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.