473,324 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

database >> html file via FSO?

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
4 2457
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
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
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
>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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: jaYPee | last post by:
i have split my database and created a code that will look up for the location of the mdb back end everytime the front end link has change. i'm wondering if there is a way to just create and INI...
4
by: barbara_dave | last post by:
Hi, all We have a database which was running on the server and used by several users. We can not the database now with the following message: The "*.mdb" need to be repaired or isn't a...
1
by: Borek | last post by:
Hello, I am getting the beforementioned error when trying to populate DataSet object with data taken from SQL2k database. Then I want to bind DataSet to GridView control. But when I use...
1
by: Günter Huber | last post by:
I got no choice for a Local Database File in VS 2k5b2 in the Data Source Configuration Wizard. I got VFP OLE DB driver installed... ? G
0
by: micky | last post by:
there are three wesite called A,B,C these are just share 1 database file called database.mdf in app_data it's that i wanna make design. i don't want to use sql server machine. just use...
6
by: xpcer | last post by:
Please help me to convert database. This is the problem, i work at an IT company. i'm junior database engineer at there. my task is converting database file from another format to mysql format....
1
by: ads | last post by:
how do i transfer database objects such as tables and sp to a database file in just clicks of a mouse? Originally we are using sql server 2000 as our data storage for a website but since the...
5
by: Savante | last post by:
I am trying to investigate the JET databases to enable me to save data from a datalogging program I'm writing. At the moment, I've been using tutorial 21 of the SAMS "Learn it in 24 hours book"....
1
by: akkha1234 | last post by:
Our database is running in full recovery mode and we backup the log file every hour and the database file every night. I notice the timestamp of database file *.mdf remains unchanged a few days....
0
by: Lexxzy | last post by:
Hi to all, I've a problem about to attach a recovered database file in the enterprise manager. My problem goes this way, I want to attach a recovered database file. So when I followed this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.