Allowing the Public to make updates

[JCO]

Does FP2003 have any special controls that would make it easy for the
general public to update. I have a soccer site that I would like for the
managers to input their teams information. I have approximately 30-40
managers. What would be the best way to provide passwords to the managers
to allow them to have their own (single) page linked to the main website.

Is this possible?
I don't currently use a database and not to familiar connecting one. I can
read up on it if it is the best way. I still don't understand how each of
the managers can update their page to a server.

I need to understand the theory first???

 

[Jim Buyens]

Without using a database, the best way is to create 30
subwebs and give each manager the authority to update a
different subweb. Of course, this also requires setting up
a user account for each manager, and making sure each
manager has FrontPage or some other way of creating Web
pages.

With a database, you would have to decide in advance what
kind of information the managers will enter: team rosters,
practice times, whose turn to bring the treats, whatever.
Then you design one or more database tables to contain
that information, and a table containing one record for
each manager.

You would have to write ASP or ASP.NET Web pages for
manager login, for managers to insert, change, and delete
information, and for display. Each record that contained
such data would also contain the applicable team number.

You may also want to create Web pages you (or the league
president) would use to add, change, or delete manager
information.

The manager login page would match a username and password
against values in the manager table, and if that succeeds,
the application would save the manager ID and the
manager's team number in a so-called Session variable. The
team update pages would then check to see that someone was
logged in, and refuse to operate if no one was.

The team update pages would get the team number from the
Session variable that resulted form the login. This
ensures that each manager only update record for his/her
team.

There would be some additional complexities if the same
person can manage two teams. Specifically, after a manager
logged in, you would have to offer a choice of teams to
update.

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

 

[chris leeds]

there's an easy to use and fairly FrontPage compatible site here:
http://8pixel.net it's called "simple site". I'm not sure if he's got a
wysiwyg editor but it's easy enough to incorporate one from possibly
www.interactivetools.com or www.webwizguide.com

HTH

--
Chris Leeds,
Microsoft MVP FrontPage

The email address on this posting is a "black hole". I got tired of all the
spam.
Please feel free to contact me here:
http://nedp.net/contact/