 Simple
login example |
|
| Want to show data
only to those with the proper login? Try this very simple
example. |
| ASP
Wizard 98 |
|
| For you
FrontPage 98 users, Microsoft provided the FrontPage 98 ASP
wizard with lots of good examples! |
| Administer
a SQL database with Access |
|
| Administer your
SQL Server database with Microsoft Access. Those who are
familiar with Access might find this more appealing and you
won't have to install SQL on your local machine.. |
| Commonly
used SQL code |
|
| Here are some
snippets of the most common SQL statements used with the
database wizard. |
| Populate
a drop down list with data from your database |
|
| This example adds
a drop down populated from a field in the database table to
help you refine a search. |
| Using
the Onchange command |
|
| Follow these
instructions to make your drop down list auto submit when a
selection is made. |
| Setting
up your database connection using ODBC |
|
| In order for
FrontPage to function properly with records in your
database, you must first establish a connection. There are
two ways in which this connection can be established... |
| ASP
Wizard 2000 |
|
| Microsoft ASP
Wizard. This wizard builds a web with the pages you will see
when you click this link. Many good examples and How To's! |
| Use
a Form to post information to a Database |
|
| FrontPage 2000
has expanded its support for database management. To post
information to a database using an HTML form, follow these
steps... |
| Setting
up your database connection using ADO |
|
| FrontPage 2000
includes a new interface to configure your database - a new
database option in the Web Settings dialog box that allows
you to set up a wide variety of data sources instantly. |
| Retrieve
Information from a Database with a Form |
|
| In Microsoft
FrontPage 2000, you can use the Database Results Wizard to
create pages that let visitors display specific
information from your database. To display specific
information from a database using criteria based on a form,
follow these steps.. |
| Display
an Image Using Data from a Database |
|
| With FrontPage
2000, you can use information from a field in a database to
display images on your Web page. |
| Create
databases with an HTML Form |
|
| In FrontPage
2000, you can automatically create an Access 2000 database
in your FrontPage web using the fields of your HTML form. |
| Custom
Confirmation Page |
|
| Create a custom
confirmation page with results submitted to your database |
| Using
a double search box to return data |
|
| When you use a
double search box, each box is assigned to an individual
field in your database table. |
| How
to filter a database query using a drop down list |
|
| FrontPage®
2000 enables you to create a database query that results in
a list that displays all of the records in a particular
field. This article describes the steps you can use to limit
the results of another database query. |
| More
SQL reference code |
|
| More references
to SQL code. |
| Passing
a parameter in a hyperlink |
|
| You can set the
hyperlink properties of any datafield to contain a value
from the database results. |
| Form
verification before final submit |
|
| Use this example
if you want users to verify their form information prior to
final submission to your database. |
| Simple
ASP code samples |
|
| List of some
very simple ASP sample code. Good reference for new users
wanting to learn more about VBScript. |
| Password
Protect ASP Pages |
|
| Check out this
tutorial to learn how to password protect any ASP page in
your web! |
| Email
Newsletter |
|
| Create your own
email news letter with ASP and an Access database. Complete
tutorial. |
| Refer
a site to a friend! |
|
| Let your users
email a link to your site to their friends using a form and
an ASP email component. |
| Random
Ad Rotator |
|
| Use the built
in IIS Adrotator Object to rotate advertisements on your
page. |
| Event
booking application |
|
| Complete tutorial
for an event booking site includes: Update, Delete, View and
the use of Alias' with joined tables. |
| Date/Time
data types |
|
| Modify your
FrontPage generated code to work with date/time data types
to perform searches. |
| New
Improved Password Protection Example |
|
| This example uses
more straight ASP to password protect your ASP pages. |
| Directory
listing with the FileSystem Object |
|
| Create a table
of contents from a directory using ASP and the FileSystem
Object. |
| Memo
fields displayed as continuous text |
|
| Memo fields from
Access are displayed as a continuous sentence even if you
entered line returns when filling out the form |
| Send
data to database and email |
|
| This example
will show you how to use FrontPage to send form data to both
an email address and a database |
| Send
data to database and email |
|
| Download this MS
white paper with complete code for sending form data to a
database and an email address using CDONTS |
| Breaking
memo fields |
|
| When displaying
a memo field from an Access database, use this example if
you want the spaces between paragraphs to show |
| Reserved
words in Access |
|
| Complete list of
reserved words that you cannot use to name your fields in an
Access database |
| Collecting
and displaying customer product reviews |
|
| This example
shows you how to create an application that will allow users
to post a review of the products in your database |
| Alternating
row colors |
|
| This example will
show you how to alternate row colors in your FrontPage
database results region table. |
| Dynamic
Drop Downs |
|
| Populate drop
down boxes from your database based on your selections. Hide
items until they are ready to be displayed... |
| Doing
math on form results |
|
| This example
explains how to add form fields together before submitting
them to your database. |
| Displaying
date formats using the Frontpage DRW |
|
| The Question
is: How to display date in the DRW as dd/mm/yyyy? Answer: We
will use an example with a Database Called Staff and Table
called StaffInfo. The table has the following fields.
StaffName, Salary, DateJoined. |
 FP2002:
How to use the DRW to create a 2 column display of database
records |
|
| This tutorial
will show you how you can create a 2 column display of
records from a database. On the left, hyperlink a short
description using a few columns from the database results.
On the right, details of the hyperlinked value from the left
column will display, including a photo, if available. |
| UNIX
Support for Microsoft FrontPage Server Extensions |
|
| Ready-to-Run
Software's UNIX support for Microsoft® FrontPage® 2002
Server Extensions and Microsoft® FrontPage® 2000 Server
Extensions. The purpose of this web is to provide support
services for the FrontPage 2002 Server Extensions for UNIX
and the FrontPage 2000 Server Extensions for UNIX for the
Microsoft FrontPage products. We've provided a number of
resources here to help you resolve problems, report bugs,
and suggest improvements to the products and service. |
| Using
FrontPage Without the FrontPage Server Extensions |
|
| For many people,
the Microsoft FrontPage server extensions are the most
compelling reason to use FrontPage for website design.
However, FrontPage is a robust website development
application even when used without the server extensions,
provided you use a little trial and error to find out what
works best for you. |
| Working
with PHP |
|
| PHP is a
server-side scripting language that's becoming increasingly
popular. It combines the capabilities of a CGI scripting
language like Perl, with the convenience of being embedded
in Web-page HTML code like JavaScript. Most major
Web-hosting companies are adding PHP to their list of
supported features, so if you haven't tried this powerful
scripting language yet, you may want to check it out. |
| Introduction
to FrontPage Database Features |
|
| You can use
Microsoft® FrontPage® 2000 to easily integrate database
power into your Web site like a true database expert. New
features built into FrontPage 2000 enable your site to
collect information and enter it directly into your
database. You can create reports from that data on the fly
with custom ASP pages designed specifically for you. You
don’t need database experience when integrating with
FrontPage 2000 -- it does most of the work for you. With
FrontPage 2000, a Web server and just a few clicks you can: |
| Dynamic
Sorting of Database Results in FrontPage |
|
| On the Internet
or an intranet, it is common to see database query results
or reports in a table that can be easily sorted by clicking
a column heading. Using the new database integration
features in Microsoft FrontPage® 2000, you can have this
functionality on a Web page without needing to know
structured query language (SQL) or custom programming.
|
| Database
Connectivity using FrontPage |
|
| Lots of FrontPage
database connectivity links, resources, etc. Links cover
queries, ADO,ASP, Server Extensions, and more. |
| FrontPage
2002 Database Interface Wizard (DIW) Tutorial |
|
| FrontPage 2002
has added a new feature, the Database Interface Wizard (DIW).
This wizard walks you through the creation of a set of
front-end administration pages for adding, modifying and
deleting records in your database through the browser using
forms. |
| Starting
out with the FrontPage 2000 Database Results Wizard |
|
| The FrontPage
2000 Database Results Wizard can be used to build complete
ASP database applications, including queries and forms which
allow data to be added, updated and deleted from the
database. Because several database results regions can be
placed on the same page, it is possible to create a complete
data maintenance application on a single ASP page using
FrontPage 2000. |
| Getting
Started with FrontPage |
|
| This is a short
movie covering the basics of getting started with FrontPage. |
| Multi-Column
HTML Table Results from a Single Database Column |
|
| You can display a
single database column horizontally across a multi-column
HTML table using the FrontPage Database Results Wizard (DRW).
For example, here is a 3-column HTML table displaying
results from an 11 record database containing U.S. State
abbreviations |
| Bar
Charts using the FrontPage Database Results Wizard |
|
| The FrontPage
Database Results procedure presented here provides a simple
way to display survey information in a horizontal bar chart. |
| Displaying
FrontPage Database Results as an Excel Spreadsheet |
|
| The FrontPage
2000 Database Results Wizard (DRW) allows you to query
information in a database and display it as an HTML table.
You can also display the information as an Excel spreadsheet
within the user's browser (if the user is running Internet
Explorer and has MS Excel installed on their machine). The
user can analyze the DRW results with Excel and save the
results as an Excel spreadsheet. |
| FrontPage
Include Page Tutorial |
|
| A powerful, yet
often under used feature in FrontPage 2002 is the component
called "Include Page". I use it for quickly adding
navigation bars, repeated addresses, or a recurring strings
of html and in place of the FrontPage Shared Border
component. The great feature of using this component is if
your client decides to add or change the navigation of their
site, the changes only have to be made one time. |
| Subtotals
using the FrontPage Database Results Wizard |
|
| You can display
subtotals using the FrontPage Database Results Wizard (DRW)
although it's not simple nor particularly efficient to do it
using the DRW. Here's an example of subtotals using the DRW |
| How
to create a FrontPage Database Connection |
|
| In this
tutorial, we are going to learn how to create a Database
Connection in a FrontPage web. This article applies to
FrontPage 2000 and 2002. |
| Photo
Gallery Tutorial |
|
| The Photo Gallery
component is included in Front Page 2002 - with the help of
a Wizard, various layouts can be accomplished. The following
pages will attempt to show you how to use this component -
from the preparation required to customisation of both
thumbnail page and larger image displays. |
| Creating
a basic form in FrontPage |
|
| This is a FLASH
movie walking you through the steps of creating a basic FORM
in FrontPage |
| Making
changes to your live web site |
|
| This FLASH movie
walks you through the steps of making changes/updates to
your live web site using FrontPage |
| Building
a discussion forum in FrontPage |
|
| To create a
protected web to restrict or monitor user access on a server
that supports self-registration through a web browser
(UNIX), you must first create a discussion web as a sub-web
to the root web. (Windows NT security and Microsoft IIS do
not allow registration through a web browser.) Your host
must also allow sub-webs on the server. |
| Custom
Hit Counter |
|
| You can create
your own custom hit counters to match the style and look of
your site, as long as you have FrontPage server extension
support for your web. This component is supported on all
versions of server extensions. |
| Hidden
Hit Counter |
|
| This hidden
counter is not really 'invisible', but will be practically
undetectable in your page. In an image editing program (such
as Image Composer), create an image 3px by 3px or larger as
a solid .gif (.jpg will not work), the same color as your
background, and save the image in the 'images' folder of
your web using the 'save as' command from the drop-down. Do
not make the image transparent. |
| Tutorials
for FrontPage beginners |
|
| These are
extensive tutorials or courses that will take a beginner
though most of the features of FrontPage in a
straightforward style. If you know of any others that should
be included please let us know. |
| How
To create a site poll in FrontPage |
|
| You can create
a basic poll in FrontPage to help make your site more
interactive for your viewers and get some feedback from your
visitors. The results will be stored in a text file on the
server. If you want the results of each submit to also send
you an e-mail, make sure the e-mail transport has been
configured on the server to allow this. You can also use
special scripts to display the results, but for now we'll
keep it simple. |
