Display form input on a page

  • Thread starter Thread starter Anonymous Chief
  • Start date Start date
A

Anonymous Chief

Hi,

I would like to be able to diplay form inputs to a page. The form will
include an item name, problem, and status. I would like all that stuff to
show on a different page. I would then like to be able to go back to that
displayed page and change the status of any item without having to fill out
a different form with a new status

Here is an example:
I set "Bob" to "Not feeling well". Then Bob displays on another page as not
feeling well. Two days later, I edit that page with either a button, or
another form with a drop down list or something, and change the status "Not
Feeling well" to "very healthy"

Please Help.
Anonymous Chief
 
This depends a lot on your exact situation, but in most cases you need to
write ASP.NET or ASP code to save the form input in a database, to select the
record you want at a later time, and to display it. There are generally too
many requirements and exceptions for FrontPage to do this "out of the box".

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
This is called form validation. Your implentation requires custom code.
Do a google search for "form validation" and "ASP" "Javascript" or "PHP"
for the script language you want to use.

If the pages will ran on a server with FPSE, you can use FP for basic
form validation. Click on help in FP.

....PC
 
Thanx for all your all you help guys. What I want to know is:

1. How do I get the stuff displayed on that page to be editable later on.
There has to be a person with access to the form that will input the
details. I do not want anyone to have access to change the contents on that
page.

2. I want to use this page to show updated statusses of something so that a
person will go there to check what the current status is, more or less like
some server statuses I see on some webhosts, though my stuff is work
related.
 
Right. When you input data for the first time, some program code adds the
information to a database.

Later, the same or a different person (whoever you configure) can specify
the key of that record, and then some program code retrieves the information
and emits a Web page with form fields that contain the current database
values.

Then, when the visitor clicks an Update button (or whatever you decide to
call it), some program code copies the potentially updated values back into
the database.

As to where this program code comes from, you have to write it yourself.

As to securing pages so that only certain people can use them, this usually
requires a combination of Web server configuration and (guess what) program
code that you write yourself.

FrontPage can't do this sort of thing with a click and a wink because there
are too many variations among pages of this type.

Have you ever done any Web server programming before?

Is your Web server Windows-based or Unix?

If Windows, does it support ASP.NET or ASP?

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------
 
If your host supports FPextensions, ASP and Access database (must be
Windows server) look at Database Interface Wizard. This can password
protect the editing and viewing pages. A separate page can be used
for submission, and public viewing if required.
 
Thanks Jim,

My webserver is on a Linux server. I am not familiar with ASP.NET or ASP,
neither am I good with php. You just gave me an idea though. The idea being
that I can use an access database to do my task. Securing the input form is
easy, I can just add it to a secured page.

Are you familiar with Frontpage's ability to use an input form to update an
access database that the webserver creates. Oh, sorry for saying "are you
familiar", of course you are.

Anonymous Chief
 
Hi Ronx,

So funny I just asked about that issue. The thing is that my webserver runs
on Apache on a Linux machine. Is there another equally easy way of doing
this on a Linux server? By the way, how can I make my post go back to the
top of the newsgroup listing each time someone updates it. I am using
Outlook Express?
 
You can not use Access under Linux/Unix, only under Windows IIS.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
You cannot use Access on Linux servers, nor can you use asp.NET. Most
Linux servers cannot run ASP either.

The usual database on Linux is mySql, with PHP or Perl/CGI as the
scripting engine.
FrontPage has little or no built in assistance for these.
 
Thanks Jim,

My webserver is on a Linux server. I am not familiar with ASP.NET or ASP,
neither am I good with php. You just gave me an idea though. The idea being
that I can use an access database to do my task. Securing the input form is
easy, I can just add it to a secured page.

Are you familiar with Frontpage's ability to use an input form to update an
access database that the webserver creates. Oh, sorry for saying "are you
familiar", of course you are.

Anonymous Chief
Click to expand...
 
Hi guys,

I finally got it. Instead of using Frontpage, I used Excel. I do my formulae
and stuff to format text based on certain criteria. I even have formulae
that relies on dates, so this makes it so much easier cos I can add more
fields. The trick is that I can get Excel to automatically update an html
file that excel creates on my webserver each time the file is saved.

Thanks a lot all you generous contributors. I wouldn't have come up with
this without your productive critic.

Keep the group live guys. Thanx

Anonymous Chief
 
Back
Top