template and database pages

[Michael Stumpo]

I have a template created in FP2003. I need to have
information from a database to be available on the
template pages so users can see updated information as
they surf the site (news updates, etc.).

Since the DWT is not an ASP page, I get an error. How can
the database information be displayed on pages containing
DWT content even though they are ASP pages.

-M

 

[Jim Buyens]

-----Original Message-----

I have a template created in FP2003. I need to have
information from a database to be available on the
template pages so users can see updated information as
they surf the site (news updates, etc.).

Since the DWT is not an ASP page, I get an error. How
can the database information be displayed on pages
containing DWT content even though they are ASP pages.

Ignore the error and continue. The database code should
work OK when it finally arrives in your ASP pages.

If it doesn't, please repost to this thread and incldue
the exact error message.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Michael Stumpo]

Jim,

I get the following error:

Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '../_fpclass/fpdblib.inc' was not found.
/pewebsitemockup01/Default.asp, line 102

This file was missing from the _fpclass folder. I copied
it from another web and "recalculated hyperlinks", closed
the web and opened again, but still get the same error.

-M

 

[Michael Stumpo]

Jim,

I discovered something. My template page (template01.dwt)
is in \template\ folder.

The page I am having problems with is Default.asp in the
root folder. When I look at the code on default.asp for
the _fpclass location, it points
to ..\_fpclass\fpdbrgn1.inc.

If I change it to below (for default.asp)
<!--#include file="_fpclass/fpdbrgn1.inc"-->

the page works. Somehow I don't think this is by design.

It would appear then, that EVERY page (since I need the
database content to be displayed) should need to be
changed in order for this to work.

-M

P.S. I hope this is not the case.

 

[Jim Buyens]

Yes, it seems that FrontPage doesn't adjust the path in the statement
<!--#include file="_fpclass/fpdbrgn1.inc"-->
automatically for you.

This is seeming move and more like a worse and worse solution. I had
reserveations about hitting this database once per page hit anyway.

What's so special about this news that you have to keep it in a
database and refresh it every few seconds for every visitor? Couldn't
you store it in a text file or something?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Thomas A. Rowe]

FP has never updated the SSI statement. You either have to correct the path
on all pages or change it to use Virtual, instead of File.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Michael Stumpo]

I never said I had to refresh it every few seconds. My
partner who knows nothng about web development wants to
be able to fill out a form and enter new company news as
needed.

Database seems like the solution. I have the DRW set to
to display new items for 20 days and then rotate it out
for new items. Archived or older than 20 days is on a
different page.

-M

-----Original Message-----
Yes, it seems that FrontPage doesn't adjust the path in the statement
<!--#include file="_fpclass/fpdbrgn1.inc"-->
automatically for you.

This is seeming move and more like a worse and worse solution. I had
reserveations about hitting this database once per page hit anyway.

What's so special about this news that you have to keep it in a
database and refresh it every few seconds for every visitor? Couldn't
you store it in a text file or something?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------





"Michael Stumpo" <[email protected]>

wrote in message [email protected]>...