database in Frontpage

  • Thread starter Thread starter Guest
  • Start date Start date
-----Original Message-----
I want to add a section on a website I'm making suing
frontpage that will enable my customers to check the
status of their repair by typing in their repair ticket
number. How can I do this? If you want to see what I'm
talking about visit the URL below:
http://www.netbags.com/warranty.asp? mscssid=VRBB7G12FQ399HH6XWHWHHE1DRG6DGM8

Even a small application system like this involves many
design decisions. As a result, I can't give you a very
specific answer.

In a general sense, you need to create a database of
current repair jobs, including whatever identifying
information and status you feel is appropriate. Then, you
query the database (using input from form fields as
selection criteria) and display the results.

In many cases, you'll also want to build a forms-based
security subsystem. This means the Web visitor would have
to logon with an ID and password, and then view only
those repair orders that pertain to them.

Of course, if you already have an automated system that
tracks these repair orders internally, you'll probably
want to extract the status information from that source.

To get started, you could probably use the Database
Editor component to create some pages for adding,
updating, and deleting repair records, and you could the
the Database Results Wizard to search for and display
records. However, this is definitely a low-end approach.

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

Lets say I already have a repair database from Access Is there a way to export this database to my webpage and then I can just have my customers Input a required field in order to view the status?
What Database Editor component are you talking about? Is this included in Frontpage?
 
EGarcia said:
Thank you for responding.

Lets say I already have a repair database from Access Is there a way to
export this database to my webpage and then I can just have my customers
Input a required field in order to view the status?
What Database Editor component are you talking about? Is this included in
Frontpage?

You can add an Access database to your Web, but Access forms and
reports don't work on the Web. You have to create Web pages that
perform these functions.

The FrontPage Database Results Wizard can select and display records
from an Access table, based on values the visitors enters via an HTML
form.

o To specify the criteria, click More Options on page 3 of the
wizard, then
click Criteria.
o To have FrontPage build the input form, select the Add Search Form
check
box on page 5 of the wizard.

To create a database editor, display the Web Site Template dialog box,
select Database Interface Wizard, specify a location, click OK, and
follow the prompts.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
I get this message when after completing the wizard
"This is the start of a Database Results region. The region will not work unless the page has a file extension of ".asp". The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.

at the begining of the wizard which option doi I select
 
In order test the database component locally, you must have Windows XP Pro
or Windows 2000 and have the IIS web server installed with the FP
extensions, and to use this on live site, the site must be hosted on a
Windows IIS server.

--

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

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


EGarcia said:
I get this message when after completing the wizard.
"This is the start of a Database Results region. The region will not work
unless the page has a file extension of ".asp". The page must be fetched
from a web server with a web browser to display correctly; the current web
is stored on your local disk or network."
 
You can't download IIS. You must have Windows XP Pro or Windows 2000 Pro,
and then under control panel Add/Remove Windows components you can install
it, and it will also install the FP2000 extensions, which then have to be
configured.

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
I have XP pro, thanks for the help, now I've installed the IIS. Once its install what exactly does the IIS is supposed to let me do? because I still get the same message. Is there something I have to do to sort of activate the IIS?
Thanks
 
You must publish all of your local web to http://localhost, then you must
always open them in FP as http://localhost to work on them, forget about the
webs under My Webs.. You will not be able to test any email from form
functions on your local machine.

--

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

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


EGarcia said:
I have XP pro, thanks for the help, now I've installed the IIS. Once its
install what exactly does the IIS is supposed to let me do? because I still
get the same message. Is there something I have to do to sort of activate
the IIS?
 
Thank you so much for your interest in helping me.
I finally got the repair search to work just like I want it to. This page is curently listed locally. If I want to publish the page to the internet what should I look for in a host in order for this page to work properly?
Thank you
 
You must have use a Windows based host that support the FP extensions and
Access as a database.

--

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

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


EGarcia said:
Thank you so much for your interest in helping me.
I finally got the repair search to work just like I want it to. This page
is curently listed locally. If I want to publish the page to the internet
what should I look for in a host in order for this page to work properly?
 
Hello.
I have encounter another problem with this database.
Unitl recently I had been testing the database locally, now I finally got a website name register and a web host. But when I try to create the same database(still using frontpage) in my live site I get the following message when I try to save the MS database to a folder in my web.
error message
"only XML files can be exported to an internet address (http://, Ftp://). Enter a path that points to a location on your computer or on the network"
Thank you for any advice
 
What kind of web host, Unix/Linux or Windows?
Did you publish your local copy to the remote server via FP's http mode?

--

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

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


EGarcia said:
Hello.
I have encounter another problem with this database.
Unitl recently I had been testing the database locally, now I finally got
a website name register and a web host. But when I try to create the same
database(still using frontpage) in my live site I get the following message
when I try to save the MS database to a folder in my web.
error message
"only XML files can be exported to an internet address (http://, Ftp://).
Enter a path that points to a location on your computer or on the network"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top