Include Database Results

[Stephen Green]

I've used the MS Web Template for a "dynamic School calendar". I tried to
include it in another page and got an error message in IE saying:

Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '../../_fpclass/fpdblib.inc' was not found.
/anmt/members/index.asp, line 72

The address of the referenced file is inside one of the webbots, so I can't
edit it. Is there a way around this? Do I have to recreate the calendar on
the new page?

Thanks.

Stephen

 

[Jim Buyens]

If your Web page and the included file aren't in the same
folder, try putting them both in the same folder.

Otherwise, I think yes, you'll have recreate the calendar
on the new page.

You used an Include Page component, right, and not an SSI
or any other type of include?

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Stephen Green]

Thanks, Jim. Moving the included file into the same folder as the web page
calling it worked.

Now I have another question. In Access, I formatted the date to look like
this - Wednesday, August 4, 2004 (Long Date); and the time to look like
this - 5:34 PM (Medium Time).

However in the database results page (the included page) the date is
8/4/2004 and the time is 6:00:00 PM. Do you have an idea what's going
wrong?

Thanks for your help.

Stephen

 

[Jim Buyens]

Yes, date formats you specify in Access apply only to Access forms and reports.

To custom format dates in the DRW, you have to use a custom SQL statement such as:

SELECT Format(mydate,'dd-MMM-yyyy') AS fmtmydate, ...

and then display the calculated fmtmydate field rather than mydate.

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Stephen Green]

Again, thanks.

Stephen

Yes, date formats you specify in Access apply only to Access forms and reports.

To custom format dates in the DRW, you have to use a custom SQL statement such as:

SELECT Format(mydate,'dd-MMM-yyyy') AS fmtmydate, ...

and then display the calculated fmtmydate field rather than mydate.

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)
|/---------------------------------------------------
*----------------------------------------------------


"Stephen Green" <[email protected]> wrote in message

 

[Stephen Green]

Jim!

I've been trying to figure out how to make use of your advice and example
(below), but to no avail.

I have three fields to deal with - startdate, starttime, endtime. I wanted
startdate to display as "Monday, August 9, 2004" and both times to display
as "10:00 AM".

Could you show me how to get the formatted fields into the results page??

Thanks alot.

Stephen

 

[Jim Buyens]

Your custom query would begin something like:

SELECT Format(startdate, "dddd, mmmm d, yyyy") as fmtstartdate,
Format(starttime, "hh:mm AM/PM") as fmtstarttime,
Format(endtime, "hh:mm AM/PM") as fmtendtime,
...

and they you would report the fmtstartdate, fmtstarttime, and fmtendtime fields.

For mroe information on the Format function, refer to:

http://msdn.microsoft.com/library/en-us/office97/html/output/F1/D6/S5B22A.asp

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Stephen Green]

Jim!

I understood the concept, but the execution was lacking. It works now.

Many thanks. Take care.

Stephen